Connect CDM folder in Power BI Dataflow

[admin_xlsior]

Hello everyone,

It is regarding setup Power BI Dataflow using Azure Data Lake Storage Gen2 and CDM.

Does anyone can help me to figure out what I need to fill in the Common Data Model folder path when we "Attach a Common Data Model to new Data Flow" in PBIS ?

I created a new storage account which is a Azure DataLake Storage Gen2 and already "Grant Power BI permission" just like this doc : https://docs.microsoft.com/en-gb/power-bi/service-dataflows-connect-azure-data-lake-storage-gen2#gra...

What confuse me, the sample path is having "model.json" in the end of it. From where is it ? Can I put the ADLS file system End point like "https://xxxmycdm.dfs.core.windows.net/" ? but I cannot proceed to button Create and Attach, so I guess that is wrong.

Some resources sugesting to prepare something in Azure Databricks, but this is baffled me even more. So whether this is a must or there is more simpler way ?

Thanks in advance.

[v-xuding-msft]

Hi @admin_xlsior ,

The path is automatically generated when you configure the workspace dataflow storage. That you need to fill in is the same as it in the picture. It needs to contain "model.json". 

There are the related documents you can reference.

Add a CDM folder to Power BI as a dataflow (Preview)

Configure workspace dataflow settings (Preview)

Best Regards,

Xue Ding

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

[admin_xlsior]

Hi,

Thanks but the point is the ADLS storage and the file not coming from PBIS Dataflow. As mentioned, it is created and populated (the file) by Azure Datafactory.

[Willgart]

did you still have thisissue?

I'm trying to connect to my owndata lake storage too, and its not working