Error in Power BI: "Column 'cachedEntity' not found when selecting Data Flow Gen 2 in Fabric"

[Luciano_Ingrass]

Hello Community,

I'm encountering a persistent issue in Power BI when attempting to use Data Flow Gen 2 in Fabric as a data source. Regardless of the data source type — whether pulling data from a SharePoint folder in both .xlsx and .parquet formats, or accessing data via a web API — I repeatedly face an error stating: "Column 'cachedEntity' not found in table." Notably, there is no column named 'cachedEntity' in any of my datasets, which adds to the confusion.

Configuration and Context:

• Platform: Power BI Desktop
• Data Source Type: Data Flow Gen 2 in Fabric
• Data Variants: Data extracted from:
  • SharePoint folder (formats: .xlsx and .parquet)
  • Web API
• Troubleshooting Done: Refreshed datasets, reconnected data sources, and verified that no erroneous column references exist in my Power Query transformations.

What I Need Help With: Has anyone else encountered this error or knows what might be causing this specific issue with Data Flow Gen 2 in Fabric? Any suggestions on additional steps to resolve this would be greatly appreciated.

Research Done: I've searched the forum and haven't found a similar issue. I am reaching out hoping someone might have insights or has resolved something similar.

Attachments: 

Thank you all in advance for your time and assistance!

Best regards, Luciano Ingrassia

[amitchandak · Accepted solution]

@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

[FinPowerDev]

I have been trying the same thing. The staging for a blank query worked but not for a sharepoint list in dataflows. Staging is automatically disabled when choosing a lakehouse as a destination. The options : choose staging leading to refresh failures or disable staging but unable to choose a lakehouse as destination. If anyone can assist, that would be great. Thanks

[vsamautomation]

it solved mine too

[iTrustOps]

I'm having this same issue. I've tried connecting this same dataflow to a new powerBi project and get the same error. 

[Luciano_Ingrass]

I've been conducting some research and found that the error stopped occurring when I began saving each instance of the data flow as an object, either in a DataMart or in the DataLake, depending on the intended use.

[amitchandak · Accepted solution]

@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

[Luciano_Ingrass]

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

[Anonymous · Accepted solution]

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!

[kapildangey]

Took me two days to try bunch of things to figure that none of them worked... until i tried this. Thank you