Wait?!? I can’t conditionally format a Line Chart in Power BI?
You have a requirement that your line chart needs to be conditionally formatted. But wait! There's no option to do that within Power BI? Go to another tool? NOPE! Adam has you covered!
When Sorting Fails: Dynamic Formatting mistakes with Measures
Have a measure that you want to format as a string in Power BI? But then the sorting doesn't work on it? What do you do? You can't sort by column with Measures. Patrick shows you how you can leverage Dynamic Formatting! Create dynamic format strings for measures https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings Zoe Douglas: https://twitter.com/datazoepowerbi https://www.linkedin.com/in/zoedouglas-data/ Phil Seamark: [...]
At last!!! Power Query within Power BI Report Builder!
With Power Query being available for Power BI Paginated reports in Report Builder, you can now do something that was very hard to do in the past. Patrick shows you what's new! Get data with Power Query available in Power BI Report Builder (Preview) https://powerbi.microsoft.com/en-us/blog/get-data-with-power-query-available-in-power-bi-report-builder-preview/ Connect to Snowflake, Databricks, and others with Power Query Online [...]
Boost DAX Performance in Power BI with Dual Mode
Don't ignore Dual Mode! If you are leveraging DirectQuery and Import in your Power BI semantic model, you could have some performance problems you aren't aware of. Patrick shows you what's going on!
Wait!?! It’s the same data source! What’s going on???
Think you are using the same data source in Power BI? Maybe you aren't? Patrick shows you how this can affect DAX Query performance and how to correct it.
Copilot for Power BI: Your Ultimate Copilot Guide
Have you used Copilot for Power BI? Do you know there are different copilots within Power BI? Carly joins us for the ultimate Copilot for Power BI guide! Overview of Copilot for Power BI (preview) https://learn.microsoft.com/power-bi/create-reports/copilot-introduction Create report pages with Copilot for the Power BI service https://learn.microsoft.com/power-bi/create-reports/copilot-create-report Create a narrative with Copilot for Power BI [...]
Exploring Dynamic Subscriptions for Power BI reports
First, we had dynamic subscriptions for Power BI Paginated reports. Now they are available for Power BI reports! Patrick walks you through how to take advantage of them! Dynamic per recipient subscriptions for reports (Preview) https://learn.microsoft.com/power-bi/collaborate-share/power-bi-dynamic-report-subscriptions
How to connect to Microsoft Fabric Items from Power BI Desktop?
If you're in Power BI Desktop, how do you actually connect to Microsoft Fabric items like a lakehouse or warehouse? Adam walks you through different options and how this relates to various connectors.
Decoding Direct Lake: The Truth Behind DirectQuery Fallback
Direct Lake in Power BI could possibly fall back to DirectQuery. Do you understand why this would happen and when? Patrick walks you though what you need to know when leveraging data from OneLake in Microsoft Fabric. Direct Lake https://learn.microsoft.com/power-bi/enterprise/directlake-overview
Include in Refresh can trip you up within Power Query
You disabled Include In Refresh in Power Query, but it's still being used? And you still need to provide credentials for your Power BI Semantic Mode? What?!? Adam breaks down what's going on. Managing query refresh in Power BI https://learn.microsoft.com/power-bi/connect-data/refresh-include-in-report-refresh