Cannot create a dataflow from CDM folders in ADLS Gen2

[sguduru]

Hi Team,

I am trying to consume data stored in ADLS Gen2 CDM folders from PowerBI. I am getting the following error when I create and attach model.json file. I gave permissions just like how it was mentioned in the docs page - https://docs.microsoft.com/en-us/power-bi/service-dataflows-add-cdm-folder . Checked the model.json file path URL to be URL encoded with no spaces. Storage account has reader permissions to Power BI Service. Also, tried creating CDM folders different ways - from PowerApps, D365 FO Entity Store Data Lake integration, all giving the same error. Please let me know if anyone has suggestions resolving this error.

[Icey]

Hi @sguduru ,

After some research, I found we can get the CDM folder path in Dataflow settings: https://docs.microsoft.com/en-us/power-bi/service-dataflows-configure-workspace-storage-settings#get...

For your issue, I would suggest you check if the path you getting is following the steps in above document. And hope this blog will give you some help.

If there is still some issues, as I don't have Azure Data Lake Storage Gen2 account to test currently, I would suggest you create a support ticket to get dedicated support. 

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[sguduru · Accepted solution]

Thank you, Icey, for your response.

I got some help from PowerBI engineering team and able to resolve the issue.

The model.json file path is showing incorrect value in the file properties. 

It should have https://<storagea account name>.dfs.core.windows.net/ instead in my case it was coming as https://<storage account name>.blob.core.windows.net/. Also there are some special characters instead of "/". When I corrected for these two, the issue is resolved.