Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We are using Azure Data Lake Gen 2 and have been able to successfully create dataflows to the powerbi folder in Azure. We are trying to create a dataflow from Power BI that reads the default.manifest.cdm.json per the instuctions. The Power BI connection works but when the Power Query form opens, we get the following error message.
DataSource.Error: Cdm failed to generate manifest. Folder path: '/powerbi/', file name: 'default.manifest.cdm.json'
I have searched for hours for a blog, video, or instructions on this topic but thus far have not found any solutions.
Help!
Reproduced the error and identified the necessary permissions required for the model.json to be read by Power BI Desktop. Highlighting the minimum permissions and common errors if the permissions are not assigned.
Permissions Needed:
Common Errors:
Hi @Pappy54 ,
Has your problem been solved? If it is solved, please mark a reply which is helpful to you.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
Hi @Pappy54 ,
Currently, in Power Query Online, the Azure Data Lake Storage Gen2 connector only supports paths with container, and not subfolder or file. For example, https://<accountname>.dfs.core.windows.net/<container> will work, while https://<accountname>.dfs.core.windows.net/<container>/<filename> will fail.
And I find some articles, please see if they are helpful:
Cannot create a dataflow from CDM folders in ADLS Gen2
Unable to read CDM default.manifest.cdm.json
The Common Data Model in Azure Data Lake Storage – Power BI Dataflows
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |