Power BI Tutorial for Beginners (2024)
Learn how to use Power BI with this beginner tutorial! Get started on creating visualizations, building reports, and analyzing data with this powerful tool. Get a head start on using Power BI!
What happens to the incremental data???
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!
Incremental Refresh with your Warehouse without a date in Microsoft Fabric
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/
9 hidden gems about On-Object Editing in Power BI
On-Object editing in Power BI has had a ton of updates! Adam walks through 9 hidden gems you probably didn't know about using it. You definitely want to see the last one! Power BI December 2023 Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-december-2023-feature-summary/ Use on-object interaction with visuals in your report (preview) https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction
Thinking about your DAX Queries like a SQL Query in Power BI
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!
Create a measure from a filtered visual in Power BI? Of Course, you can!
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.
Exploring Custom Spark Pools in Microsoft Fabric Lakehouses
With Microsoft Fabric Lakehouses you begin with a starter pool for Spark. Patrick shows how you can create custom pools and have those as the default for your workspace. Configuring starter pools in Microsoft Fabric https://learn.microsoft.com/fabric/data-engineering/configure-starter-pools How to create custom Spark pools in Microsoft Fabric https://learn.microsoft.com/fabric/data-engineering/create-custom-spark-pools
Control ACCESS to your Microsoft Fabric Lakehouse or Warehouse
Want to secure your data in Microsoft Fabric? Adam walks you through different options and layers to control access and prevent people from looking at data they shouldn't for your lakehouse or warehouse! Roles in workspaces in Microsoft Fabric https://learn.microsoft.com/fabric/get-started/roles-workspaces Row-level security in Fabric data warehousing https://learn.microsoft.com/fabric/data-warehouse/row-level-security Row-level security https://learn.microsoft.com/sql/relational-databases/security/row-level-security?view=sql-server-ver16 Column-level security in Fabric data [...]
Boost your productivity with DAX Query View in Power BI Desktop!
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/
Let’s look at using some PySpark in your first Microsoft Fabric Notebook
Not sure about Notebooks or PySpark in Microsoft Fabric? Simon Whitely joins us to help get you started and to demystify what it's all about. He uses some SQL also! How to use Microsoft Fabric notebooks https://learn.microsoft.com/fabric/data-engineering/how-to-use-notebook Use a notebook to load data into your Lakehouse https://learn.microsoft.com/fabric/data-engineering/lakehouse-notebook-load-data Simon Whiteley https://www.advancinganalytics.co.uk/ https://www.youtube.com/@AdvancingAnalytics https://twitter.com/MrSiWhiteley https://www.linkedin.com/in/simon-whiteley-uk/