All Code!!! Extract ZIP files with Notebooks in Microsoft Fabric
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!
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.
We got a new DAX Query view within Power BI Desktop and it's INSANE AMAZING! Patrick shows how you can leverage the new feature. Work with DAX query view https://learn.microsoft.com/power-bi/transform-model/dax-query-view Power BI November 2023 Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/#post-25061-_Toc150157949 Deep dive into DAX query view and writing DAX queries https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-and-writing-dax-queries/
Want to start using Azure Databricks with OneLake in Microsoft Fabric? Patrick walks you through how to get this working! Storing the data in OneLake opens up a lot of other possibilities. Using Azure Databricks with Microsoft Fabric and OneLake https://blog.fabric.microsoft.com/blog/using-azure-databricks-with-microsoft-fabric-and-onelake Integrate OneLake with Azure Databricks https://learn.microsoft.com/fabric/onelake/onelake-azure-databricks