Forum Discussion
Advocate IDataflow based reports stopped working last night
Hi FredrikW ，
Based on the information you provided, the issue seems to be related to the fact that the ADLS Gen 2 connector does not support Blob URLs in the data flow configuration. I checked the documentation and it mentions that the user must have the Storage Blob Data Owner role, the Storage Blob Data Reader role, and the Owner role at the Storage Account level (the scope should be for this resource and not inherited). Any applied role changes may take a few minutes to synchronize and must be synchronized before the following steps can be completed in the Power BI service. You can check if the problem is due to a role change.
Also the documentation mentions that you can use ADLS Gen 2 connectors for data connectivity.
You can refer to the following documentation for more information
Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Learn
Azure Data Lake Storage Gen2 - Power Query | Microsoft Learn
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Advocate IHi
Thanks for feedback.
I am not using DataFlow Storage in Azure DataLake, and have never used ADLS Gen2 Connectors.
This is something that MS is doing in the background.
I have a CDM folder structure that i stored in ADLS (Gen2) that is generated from Dynamics 365 FnO.
I have defined in PowerBI workspace a Dataflow that points to the model.json file (using DFS path).
In the report i then use PowerBI DataFlow (legacy) or powerPlatform Dataflows to read this to get my tabels.
After updateing PowerBI desktop I now get an error in desktop aswell.
After this i looked into the model.json file in the CDM structure. This file contains URI to the CSV files that holds the data. These URI are using the BLOB path.
I tried to hack a model.json file and changed the BLOB paths to DFS paths, and then it works.
So in my opinon this is a PowerBI issue, based on the limitation it has to read data from CDM.
I will create a support ticket with MS to se what they say about it..
Hi FredrikW ,
I'm having the same issue and have replaced blob.core with dfs.core in the model.json file. It works but after a few hours the json file is automatically refreshed with blob.core. I assume a process is pushing the model.json file from somewhere but don't know where from.
Did you get a response from MS team?