Last week Reid Havens invited me to speak in his YouTube Livestream series. Reid is one of the most prominent and creative Power BI experts. Combining a mastery of the Power BI technology stack with a rare artistic talent to generate the most stunningly beautiful yet-most-practical dashboards, he is a force of nature you would want to closely follow – If you haven’t already subscribed to his YouTube channel, now is the time π
In this Livestream recorded session, our topic was: Power Query – What is it good for? I hope you will find it useful and motivate you to master the arts of Power Query. If you are already very strong in visualizations, learning Power Query will help you to become a true master and control the shape of your art.
When You Use Power Query In Microsoft Excel, Is It The Same In BI?
Yes. The version in Excel is been updated less frequently and you donβt have all the 3rd party connectors due to business contract or maturity (Excel is more strict)
So In Excel, Can You Connect Power Automate Or Flow Projects To Make Your Own Connectors & SDKs?
It sure I understand the question. Would you like to connect to Power Automate using Power Query? Can you please explain the scenario?
Lets Say That I Am Using Power Query To Do Web Scraping And Want To Make My Own Web Connector, Can I Do That In Power Query On Excel?