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
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

  • Luciano_Ingrass's avatar
    Luciano_Ingrass
    Frequent Visitor
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      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!

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

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

    • Didi's avatar
      Didi
      Frequent Visitor
      6 months ago

      Hello, I am having the same problem and wondering if you ever got the error message resolved? i have the data destination set to lakehouse. the dataflow worked but when i refresh, it gives me an entity problem. I then decisded to use desktop to connect to the data flow gen 2 in fabric and saw this error - cachedEntity of the table was not found. Pls let me know if you were able to solve this. I am lost as to whats happening.

  • 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