Скачать или смотреть Abstract Thesis 75: Power BI Datamarts- SQL, Direct Query Dataset, SSMS, Dax Studio, Service Report

Power BI Datamarts feature was released in May 2022. This video explores the feature in detail.
Power BI for Advance User:    • Expertise Power BI- How to Change Connecti...  

Power BI Tutorial Series for Beginners:    • Power BI for Beginners 1: Loading Data, Cr...  

Power BI Abstract Thesis Episode 75: How to create Datamarts, Run SQL on service to check data, Create reports using Direct Query Dataset of Datamart on Power Bi service. How to create a report on power bi desktop using Direct Query Dataset of Datamart. How to create a report on power bi desktop using Azure SQL behind the datamarts
Datamarts are a fully managed database that enables you to store and explore your data in a relational and fully managed Azure SQL DB.

--Content
00:00 Introduction
00:11 what is Power Bi Datamarts
04:00 Create Power Bi Datamart
15:00 Create Report in Service
20:00 Create Measure
25:00 Create Date Table -Using M (Power Query)
30:00 Using Datamart on Power BI Desktop as Live connection
33:00 Using Datamart on Power BI Desktop as Direct Query Connection
38:30 Using Datamart's SQL Server on Power BI Desktop as Import Mode
43:00 Using Datamart's SQL Server on Power BI Desktop as Direct Query
46:00 Using Datamart's SQL Server on SSMS
48:00 Can we use Datamart's Dataset on SSMS as Dataset
49:00 Using Datamart's Dataset with DAX Studio
51:00 Can we use Datamart's Dataset with Tabular Editor
52:00 Using Datamart's Dataset with Excel
54:00 Check Published reports on Service
55:30 Correcting the dataset connection


Please refer to my blog on Medium on power bi datamarts:   / power-bi-datamarts  
data mart in power bi, data mart power bi, datamart in power bi

Offical Documents
https://docs.microsoft.com/en-us/powe...
https://docs.microsoft.com/en-us/powe...

Last Video: Power BI Abstract Thesis Episode 74: IsInScope - Switch Rank at different levels:    • Abstract Thesis Episode 74: Power BI IsInS...  

This link will take you to the power bi dashboard that has links for all my blogs and video -You can get all my posts at
https://community.powerbi.com/t5/Data...
Like, Share, comment, and Give suggestions for improvement, and the next post/video.

Important Links every powerbi enthusiastic should bookmark:   / important-links-every-powerbi-enthusiastic...  

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
   • Learn Power BI 2- DAX Standard, Fiscal, No...  

Also, check
Cheat Sheet — Power BI Time Intelligence Formulas Using Today -   / cheat-sheet-power-bi-time-intelligence-for...  

Cheat Sheet — Power BI Calendar that starts with any date of the month — Just two variables apart -   / cheat-sheet-calendar-that-starts-with-any-...  

~-~~-~~~-~~-~
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
   • Microsoft Power BI Tutorial For Beginners✨...  
~-~~-~~~-~~-~