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!
Hello amitchandak,
Thank you for your response. I appreciate your suggestions and have confirmed that my Data Flow Gen 2 was published and loaded correctly in the Power BI service without any errors. However, the issue with the "Column 'cachedEntity' not found" error still persists when I attempt to load the table using the dataflow connector under Microsoft Fabric.
I'm curious about your suggestion regarding the use of Lakehouse and Warehouse as sources. Could you please elaborate on how integrating these sources might be more beneficial compared to Data Flow Gen 2 in the context of Fabric? Are there specific advantages or configurations in Lakehouse and Warehouse that could potentially bypass or resolve the issue I'm experiencing?
Additionally, if you have any specific steps or settings that you could share for setting up and using the Dataflow connector successfully, it would be immensely helpful.
Thanks again for your help and looking forward to your further insights.
Best regards, Luciano Ingrassia
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!
Took me two days to try bunch of things to figure that none of them worked... until i tried this. Thank you