Create your own Power Query Connector for Power BI & Dataflows (with Miguel Angel Escobar)
HTML-код
- Опубликовано: 2 авг 2024
- Ever wanted to connect to a data source that is not listed in Power BI or Dataflows? This session will show you everything that you need to know to better understand the landscape of connectors in Power BI and Dataflows, how to connect to sources not listed in Power BI and when / how to create your own connector for Power BI and Dataflows.
GUEST BIO (Miguel Angel Escobar) 👤
Born and raised in Panama City, Panama. I’m currently a Program Manager at Microsoft for the product that changed my life: Power Query.
Before this Program Manager role, I was the Principal Consultant and President of my own company based in Panama called Powered Solutions which was a Microsoft Gold Partner in Data Analytics for many years. I'm a former Microsoft MVP, MCP, MCT and author of books related to Data Prep and Data Analytics.
RELATED CONTENT 🔗
Miguel's LinkedIn -- / escobarmiguel90
Creating Your First Connector -- learn.microsoft.com/en-us/pow...
Power Query SDK Overview -- learn.microsoft.com/en-us/pow...
VIDEO CHAPTERS 📺
0:00 - Video Start
5:00 - Start of Livestream
LET'S CONNECT! 🧑🏽🤝🧑🏽🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
CHECK OUT OUR MERCH STORE 👕
-- havens-consulting.creator-spr...
HAVENS CONSULTING PAGES 📄
Home Page -- www.havensconsulting.net
Blog -- www.havensconsulting.net/blog-...
Blog Files -- www.havensconsulting.net/blog-...
Files & Templates -- www.havensconsulting.net/files...
Consulting Services -- www.havensconsulting.net/consu...
Online Course -- www.havensconsulting.net/onli...
Contact & Support -- www.havensconsulting.net/conta...
EMAIL US AT 📧
info@havensconsulting.net
#PowerBI #powerplatform #microsoft #businessintelligence #datascience #data #dataanalytics #datavisualization #dashboard #bi #analytics #dax #powerquery #fabric #customconnector #powerquerysdk #sdk 
Наука
I am glad Miguel's demo had a few hiccups. Watching him debug and resolve issues on the fly was very helpful. It strengthens the learning concepts and highlighted the dependencies.
Good to hear! I hear that as feedback from a lot of people that troubleshooting on the fly is helpful to watch.
I'm one of those people that's still using your Power BI API custom connector 😂
It's so handy!
Me too! The dataflow datasources stopped working for a while but, maybe it was an issue with our node, either way, it’s working again now.
Intellisense in Dataflows are not intuitive as it is in Power BI desktop. I wish it could be fixed so that we can write code directly online.
I need to develop a custom connector on top of ODBC/ system DSN. is there any material available that may help develop it.
Is there any way to debug the connector? I am finiding it really difficult to understand the flow and errors it throws and fix those. I don't have any prior experience in developing a power Bi custom connector.
There aren't many tools for debugging specifically. Custom connectors are custom enough that outside of RUclips videos like this there aren't many official courses. More experts to reach out to contract when help is needed, since not a lot of people need to build them
do you have any course that can be bough in order to learn how to create those custom connectors?
I don't believe there are any specific courses on this topic specifically. Other than live streams like this, or other shorter videos / blogs to help you build them out.
Miguel is one of the owners of Skillwave though, and his Power Query content is on there.
skillwave.training/
I just learnt of the Power BI API (beta) (custom) connector but it seems it has been removed. Was it removed right after this live stream?
If so, which other connector can one use to get all of these Service usage data for further analysis?
You'll have to install it first, then you can use it :)
www.thepoweruser.com/2021/02/21/power-bi-rest-api-connector/