Forum Discussion
Error in Power BI: "Column 'cachedEntity' not found when selecting Data Flow Gen 2 in Fabric"
Luciano_Ingrass , Make sure your dataflow gen was published and loaded properly. There was no error showing on the Power BI service.
I can load a table from Dataflow gen2 , using the dataflow connector under Microsoft Fabric
Also, In case Fabric prefer, using Lakehouse and Warehouse as sources, then dataflow Gen2
Hello Luciano_Ingrass
I had the same error, but it is solved by "Enabling staging", by doing so, publish the Data Flow Gen 2
This option is disabled when you assign data loading to a warehouse or lakehouse so you have to enable manualy.
If i answered your question, mark my post as a solution! I appreciate your kudos!
Enabling staging in dataflows helped resolve the problem.
When Staging is disabled, the dataflow only contains the transformation logic. It reads from the source and writes directly to the destination (Lakehouse/Warehouse). It doesn't keep an internal materialized copy of the query results that Power BI Desktop can consume.
When you enable Staging, Dataflow Gen2 first executes the query and materializes (stores) the intermediate result in an internal staging Lakehouse/Warehouse managed by Fabric. Once the data is physically stored, Power BI Desktop can discover and read the staged entity, which is why the cachedEntity error disappears.