Forum Discussion
Attach a CDM folder to a new dataflow using Entity Store from Dynamics 365 Finance & Operations
Hello, I have successfully provisioned an Azure Storage Account (Data Lake) to be used by an instance of Dynamics 365 Finance & Operations as an Entity Store. The structure of these data is o...
Hi clausm73 ,
Have you read this document about how to add a CDM folder to Power BI as a dataflow?
In addition, based on the error message, it seem that the issue may be casued by the Common Data Model folder path.
Please check it is right. You could refer to this document which introducing how find the path.
Best Regards,
Cherry
It doesn't work.
For my demo pupose I have done:
- Created a Global Administrator Account in an Azure subscription
- Using this account I have created an Azure Storage Account - with hierarchical namespace disabled (THIS is required to be able to use it as an Entity Store Data Lake for Dynamics 365 Finance & Operations)
- Signed up for at Power BI Pro Trial license using this account
- Asserted that my Storage Account AND the Power BI service are in the same region
- Configured Dynamics 365 Finance & Operations to export data to the Data Lake
- After successful integration with Data Lake I have browsed to Storage Account CDM-folder structure and copied the URL of the model.json file.
- In the Power BI services tried to attach that CDM folder using the copied URL.
Its not working!
The only suggestion I might have to why its NOT working is:
- Power BI dataflows uses Straoge Accounts with hierarchical namespace.
- Dynamics 365 Finance & Operations exports its Entity Store to a Storage Account with hierarchical namespace DISABLED (its a requirement).