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

[@aleclippe6213]

300 views is absolutely criminal. You are amazing sir!

[@MSFT_ScottSewell]

LOL - it’s a niche topic, but I am glad you are here and finding value in this series. Thanks for the encouragement!

[@UnbelievableOdyssey]

Can Fabric Link utilise the Direct Lake feature?

[@MSFT_ScottSewell]

Yes, but I might suggest only using it for extraordinarily large Dynamics datasets with very narrow/specific requirements. I would start with import or direct query methods first most Dynamics 365 use cases.

[@erwinsanders407]

Hallo scott i like the explanations. How is the security of the data taking care. Can the user Who is using the report only see the data which he normale could see via dynamics ?

[@MSFT_ScottSewell]

See this video: kzbin.info/www/bejne/onu0mYqPa6qjbaM