Dataflow gen2 can't connect dataflow gen2

[fabconmvp]

Hello everyone,

When I connect dataflow gen2 from dataflow gen2. I got an error. So can't ı connect my dataflow gen2?

When I try I got an error "The column 'cachedEntity' of the table wasn't found"

Kind Regards,

Thank you

[Expiscornovus · Accepted solution]

Hi @fabconmvp,

Just to double check, you are trying to use an existing dataflow (gen2) as a source in the get data option of the new dataflow (gen2), correct?

Afaik that should be supported and I don't see that listed as a limitation:

https://learn.microsoft.com/en-us/power-query/connectors/dataflows

Can you share the power query M code you used for the connection/to retrieve the data from the first gen2 dataflow? Would be good to inspect that and see what is happening in your case.

[Anonymous · Accepted solution]

Thanks for the reply from Expiscornovus , please allow me to provide another insight: 
Hi  @fabconmvp ,

You can check out the following link with the same error message and I hope the solution in it helps you:

Solved: Error in Power BI: "Column 'cachedEntity' not foun... - Microsoft Fabric Community

Solved: cachedEntity - Microsoft Fabric Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Expiscornovus · Accepted solution]

Hi @fabconmvp,

Just to double check, you are trying to use an existing dataflow (gen2) as a source in the get data option of the new dataflow (gen2), correct?

Afaik that should be supported and I don't see that listed as a limitation:

https://learn.microsoft.com/en-us/power-query/connectors/dataflows

Can you share the power query M code you used for the connection/to retrieve the data from the first gen2 dataflow? Would be good to inspect that and see what is happening in your case.

[fabconmvp]

Hello @Expiscornovus,

I faced a problem this morning. However, the problem is gone suddenly and ı can connect right now and I haven't changed anything. İt is weird. Assume that dataflow needs a time? Interesting. Do you have any opinion why ı faced a problem in this morning and not faced right now?