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.
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.
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
Who needs NOCODE? Patrick takes you on a journey where you can extract ZIP files within a Notebook in Microsoft Fabric. Also found a very cool feature in Notebooks!
Join Patrick as he explores Real-Time Analytics (RTA) in Microsoft Fabric by creating an event stream into a KQL Database. It only takes a few clicks! What is RTA: https://learn.microsoft.com/fabric/real-time-analytics/overview Event Streams overview: https://learn.microsoft.com/fabric/real-time-analytics/event-streams/overview
When you add a column to your lakehouse in Microsoft Fabric, why isn't is showing up in the Power BI Semantic Model? Patrick shows you how to get it there! Gaston Cruz https://twitter.com/GastonFCruz https://www.linkedin.com/in/gastoncruz/
We got the question if you could use Field Parameters with Direct Lake in Power BI. The answer is, yes? However,... Patrick tells more! Let report readers use field parameters to change visuals (preview) https://learn.microsoft.com/power-bi/create-reports/power-bi-field-parameters Direct Lake https://learn.microsoft.com/power-bi/enterprise/directlake-overview Tabular Editor https://tabulareditor.com/ Tabular Editor Script https://github.com/tabulareditor/Tabulareditor3/issues/541
We talked about incremental data using an integer within your Synapse Data Warehouse in Microsoft Fabric. But Patrick forgot to go through what you do after staging. Well, here you go!
Want to incrementally refresh your data without using a date for your Synapse Data Warehouse in Microsoft Fabric? Patrick gives you a pattern you can leverage! Alex Powers' Blog: CHANGE (IN THE HOUSE OF LAKES) https://itsnotaboutthecell.com/2023/10/16/change-in-the-house-of-lakes/
Coming to Power BI with SQL experience? Trying to learn DAX? Patrick shows you how to think about your DAX Queries like a SQL Query in Power BI. We hope this helps you to create DAX Queries that are much more accurate and effective!
A live stream question asked if you could create a DAX measure from a filtered visual in a Power BI report. Of course, you can! Patrick uses the new DAX Query view in Power BI Desktop to show you how.