Forum Discussion

lliu08's avatar
lliu08
Helper I
5 years ago
Solved

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

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 h...
Dataflow
General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    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's avatar
lliu08
Helper I
5 years ago

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's avatar
lliu08
Helper I
5 years ago

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