Dataflow combining online and on-prem sources

---

lbendlin wrote:

In your gateway there is a setting "allow refresh of cloud data sources through this gateway".  Enable that and then try again.

---

Thank you for the reply.

I did have that checkbox checked and the problem was still occurring.

New findings:

I'm using a Premium workspace and i realized today that copying the queries as is from PowerBI Desktop, resulted in some computed entities as some of the "load enabled" queries were referencing each other.

Then I read the following in the PowerBI documentation about Premium capacity computed entities:

As a best practice, when doing computations on data joined by on-premises and cloud data, create a new dataflow for each source (one for on-premises and one for cloud) and then create a third dataflow to merge/compute over these two data sources.

Due to the urgency of resolving things, I have moved all settings tables to an Excel file stored on-premise.

I'm dealing with other issues now like dataflow not refreshing.

Once I will resolve that, I will try to take back the settings tables into Sharepoint and try the best practice above.