Forum Discussion
Cannot attach an external CDM folder to a new dataflow
After some more trials, I managed to solve the issue following this steps
- Create the ADLS2 folder in Azure Storage Explorer
- BEFORE populating the folder, assign Read and Execute permission to that folder to the user who is going to attach the CDM folder to the dataflow in Power BI Service
- Execute the Databrick notebook so that it writes inside that folder (model.json and other subfolder inherit user permission)
- In Power BI Service Create à Dataflow à Attach an external CDM folder
- Paste CDM folder path, ending with <…..>/model.json
- It works!
Step 2 and 5 are not so clear from the documentation (https://docs.microsoft.com/en-us/power-bi/service-dataflows-add-cdm-folder) IMHO.
Thanks,
Elisa
After some more trials, I managed to solve the issue following this steps
- Create the ADLS2 folder in Azure Storage Explorer
- BEFORE populating the folder, assign Read and Execute permission to that folder to the user who is going to attach the CDM folder to the dataflow in Power BI Service
- Execute the Databrick notebook so that it writes inside that folder (model.json and other subfolder inherit user permission)
- In Power BI Service Create à Dataflow à Attach an external CDM folder
- Paste CDM folder path, ending with <…..>/model.json
- It works!
Step 2 and 5 are not so clear from the documentation (https://docs.microsoft.com/en-us/power-bi/service-dataflows-add-cdm-folder) IMHO.
Thanks,
Elisa
I'm exploring using the attach CDM capability to transition our ETL to ADFv2 and then create in the CDM format so that it can be consumed in PBI. I'm trying to create my own .JSON and fold structure to test this out before going to databricks route.
Has databricks and then attaching the CDM for PBI consumption worked well for you?