Use this Power BI feature to display custom message or titles
Want a custom message or title in your Power BI report? Not happy with the formatting options of the card visual or buttons? Patrick shows you a way that can be fully customizable!
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 [...]
Some tips for your data labels in Power BI
Charts can be hard to understand sometimes. Ambiguity is never a good thing. Here are some tips for using data labels in Power BI to help your consumers better understand the meaning of the values.
Revisiting a Power BI solution with Dynamic M Parameters
Dynamic M Parameters for SQL are here in Power BI! YES!!! Let's revisit a Power BI solution and how we can take it to the next LEVEL using these! LEVEL UP Power BI Conditional Drill with Paginated reports! https://youtu.be/43CwBmaym8Q Teo Lachev's Blog: https://prologika.com/power-bi-dynamic-m-query-parameters-reloaded/ Chris Webb's Blog: https://blog.crossjoin.co.uk/2022/02/20/tsql-table-valued-functions-and-dynamic-m-parameters-in-power-bi-directquery/ Documentation: https://docs.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters
Oops! Forgot to show this…
Oops! Forgot to show how we added the Power BI Report page tooltip from our sparkline video. Well, here it is! Add a little info to your Sparkline in Power BI https://www.youtube.com/watch?v=NkRVaRUVO7s
Create Hybrid Tables with Tabular Editor for Power BI? YES!!!
Hybrid Tables are an incredibly powerful feature in Power BI. But what if you wanted to create them outside of Power BI Desktop? Patrick shows you how you can do just that in Tabular Editor! --This Year let Source = Sql.Databases("servername"), AdventureWorksDW = Source{[Name="databasename"]}[Data], internetsales = AdventureWorksDW{[Schema="dbo",Item="pbi_InternetSales"]}[Data], thisyear = Table.SelectRows(internetsales, each Date.IsInCurrentYear([OrderDate])) in thisyear --Last [...]
Make your Power BI mobile reports POP
You wanted better control over your Power BI Mobile Report layouts? Look no further. Michal Heldy joins us to walk us through how to get the most out of this new enhancement in Power BI Desktop! Connect with Michal Foster Heldy https://www.linkedin.com/in/michal-foster-heldy-70870b13/ https://twitter.com/Michal36040600
A little trick for SharePoint Online Images in Power BI
Using secure images in Power BI reports can be a pain! Patrick has a little trick for you to using images from SharePoint Online though. Check this out!
How to get Secure Images in Power BI Reports
Struggling getting images in your Power BI Report? Don't want to use anonymous URLs for the image? Patrick walks you through an approach to use secured images in your reports! Show “secured” Images in Power BI https://pbi-guy.com/2021/11/17/show-secured-images-in-power-bi/