Forum Discussion

Pappy54's avatar
Pappy54
Regular Visitor
4 years ago

DataSource.Error: Cdm failed to generate manifest

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!

 

 

Dataflow
Need Help

3 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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

  • cobrow's avatar
    cobrow
    Regular Visitor
    4 years ago

    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:

    • Reader role on Storage Account
    • Storage Blob Data Contributor on Storage Account
    • Read & Execute permissions on the Folder

     

    Common Errors:

    • Reader Role on Storage Account
    • Read on Folder

     

     

     

    • Read & Execute permission on folder

     

     

     

    • Storage Blob Data Reader (or Storage Blob Data Contributor)