Showing results for 
Search instead for 
Did you mean: 
New Member

Connecting Power Bi to D365 Entity Store via Azure Data Lake Gen2

Hi all


I'm trying to connect Power BI to a D365 entity store replica in a Azure Data Lake Gen2 storage account. Currently, we have AggregateMeasures replicated in the storage account, but when I try to connect them in PowerBI I get the following error:


DataSource.Error: Object reference not set to an instance of an object.


I'm using the Azure Data Lake Storage Gen2 connector with CDM folder view, as I can see the model.json files in the data lake for the various AggregateMeasures, but I'm not sure why I'm seeing this error.


Could anyone point me in the right direction for getting this connection up and running so that I can build reports in Power BI with this data?


Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates