Рет қаралды 879
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