Power BI Dataset Refresh with On Premise SQL and Data from Cloud

[lliu08]

Hi community,

I published a PowerBI report where there are two data sources in that report, one data source is On-Prime data from SQL server and another data set is from Cloud SQL server.

I had no issues when the data are all coming from On-Premise SQL server, first time having a report with Cloud base data and On-Premise Server. 

In the dropdown for "Maps to", I can only see the Cloud base source available in my dropdown although I do have On-Premise Data Gateway set up as well.

My question is, is there a limitation in PowerBI that I cannot have one PowerBI report with one is On-Premise data source and one is Cloud base data source for the auto-refresh?

Thank you in advance for answering. 

[v-kkf-msft · Accepted solution]

Hi @lliu08 ,

PowerBI allows composite models of local data sources and cloud sources.

Under Gateway Cluster Settings, you need apply "Allow user's cloud data sources to refresh through this gateway cluster". To learn more, please see https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-mashup-on-premises-cloud 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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

[lliu08]

I do have that check off but still don't have the option of having the refresh set to one On-Premise and one cloud. 

please see photo below, I only have one selection show up in the dropdown while there are more than just one options in my data gateway cluster

[lliu08]

Answering to my own question. Problem solved now, just have to add a new connection with the same server name. 

[arvindsingh802]

You can have both type of dataset in same dataset.

to help you with current issue, would be helpful if you could share screenshot where you are seeing only could source

If this post helps, then please consider Accept it as the solution and give it a thumbs up