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!

iTrustOps's avatar
iTrustOps
New Member
2 years ago

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's avatar
    Luciano_Ingrass
    Frequent Visitor
    2 years ago

    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.