Forum Discussion

Luciano_Ingrass's avatar
Luciano_Ingrass
Frequent Visitor
2 years ago
Solved

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

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 S...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    2 years ago

    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!

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

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

Sindhu_S's avatar
Sindhu_S
New Member
4 months ago

Hi  ,

My dataflow Gen2 is already sourced from lakehouse tables. Now I am trying to connect to this Dataflow Gen2 into the Power BI semantic model using Get Data->Microsoft fabric -> Data Flows. When  I select my Daatflow Gen 2, It throws ."Expression.Error: The column 'cachedEntity' of the table wasn't found.
Details:cachedEntity" .

Any suggestions would be very much appreciated.

Thanks, Sindhu