Dataverse to Fabric OneLake - Part 4 - Connect Power BI to Dataverse Fabric Link
Part 4 - This short video shows a solid pattern for connecting Power BI desktop to the Dynamics 365 data available through the Fabric Shortcut. I grab the query, create a couple of parameters and then paste my query into a block of reusable Power Query code to set up an easy to replicate pattern.
The two parameters I create are FabricWorkspaceConnectionString and FabricLakehouseDatabase
The block of Power Query code that I always start with is :
let
Workspace = Sql.Databases(FabricWorkspaceConnectionString),
Lakehouse = Workspace{[Name=FabricLakehouseDatabase]}[Data],
Source = Value.NativeQuery(Lakehouse,"
[Your SQL Query goes here]
" ,null ,[EnableFolding=true])
in
Source
#dataverse #dynamics365 #dynamics365crm #fabricators #microsoftfabric #powerbi #fabric
Watch video Dataverse to Fabric OneLake - Part 4 - Connect Power BI to Dataverse Fabric Link online without registration, duration hours minute second in high quality. This video was added by user Scott Sewell 08 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 1,078 once and liked it 19 people.