Do you need Functions in Power Query?
You can do amazing things in Power Query! Maybe you think to create a function. But do you really need a function for that? Or is it over complicating things?
Refresh and NO DATA in my Power BI visuals???
Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you. Troubleshooting refresh scenarios https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios Data types in Power BI Desktop https://docs.microsoft.com/power-bi/connect-data/desktop-data-types Damu Venkatesan: https://twitter.com/vdamu https://www.linkedin.com/in/damuvenkatesan/
You thought DAX? Alex shows you Dynamic M-M-Magic!
We thought that DAX was the thing in Power BI. Alex proves the M-M-Magic is really with Power Query! If you wanted to be blown away but what Power Query can do, this is the video for you! Connect with Alex: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ Power Query folding https://docs.microsoft.com/power-query/power-query-folding 30 Day Challenge: Query Folding https://www.youtube.com/playlist?list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Power Query [...]
Another 30 Day Query Folding challenge!!!
Here is another 30-day Query Folding challenge video for you. Patrick takes on Day 7 and ramps up his Power Query knowledge! Will Power BI Desktop get the best of him??? GitHub Repot: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY
Blown AWAY by Column From Examples in Power Query
Column From Examples, in Power Query, keeps blowing our mind! Patrick shows you an example where he wanted to extract some data. Will Column From Examples work? Of course, it will! Check this out! Add a column from examples in Power BI Desktop https://docs.microsoft.com/power-bi/create-reports/desktop-add-column-from-example
Try limiting rows when creating reporting for big data in Power BI
Working with more data than you can use in Power BI Desktop on your machine? Patrick has a trick for you to work with the subset of data locally and all the data in the service without using Premium!
Can Patrick handle the challenge???
Can Patrick handle the challenge that Alex Powers presented to him? Can he actually complete the challenges of the Power Query 30-day Query Folding challenge? Let's find out... These are great for both Power BI and Microsoft Excel! 30 Day Challenge - Query Folding https://www.youtube.com/watch?v=9sV3hIn8VTY&list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N Day 1 Challenge - https://www.youtube.com/watch?v=KZqZsCy5DaY&list=PLKW7XPyNDgRCorKNS1bfZoAO3YSIAVz3N&index=4 GitHub Repo: https://github.com/itsnotaboutthecell/powerquerym/tree/master/%2330DQUERY Query Folding [...]
So, we just wait???
What's up with the wait time in Power BI Dataflows? Do we just live with it? What's going on and what can we do about? Adam, has you covered! Understanding and optimizing dataflows refresh https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-understand-optimize-refresh
How we optimize Power Query and Power BI Dataflows
Let's go into Adam's mind as he optimizes Power Query to make some Power BI Dataflows run faster to avoid resource usage. The result is INSANE AMAZING! Power Query M function reference https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference
To Pivot or Unpivot? That is the question!
Sometimes your data isn't shaped the right way. Have you tried the Pivot or Unpivot methods in Power Query? They can help get your data looking the right way for your Power BI reports! Pivot columns https://docs.microsoft.com/en-us/power-query/pivot-columns Unpivot columns https://docs.microsoft.com/en-us/power-query/unpivot-column