cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sethsanu
Frequent Visitor

PBIX switch from On-premise to SQL Azure still requires Gateway in the service

I have a complex PBIX file that sourced data from a single on-premise SQL Server. I published this file to PBI Service and the dataset requires a gateway - as expected.

 

I then changed the data source connection in PBI desktop to point to a SQL Azure instance instead. I then published the file to the PBI Service and the dataset is prompting for a Gateway! Not expected. 

 

I looked at the difference in the M query and both SQL Server on premise and SQL Azure use the SQL.Database method. 

 

How can I tell the PBIX file or PBI Service that I want to source from SQL Azure and NOT an on-prem SQL Server?

 

many thanks,

Seth

1 ACCEPTED SOLUTION
sethsanu
Frequent Visitor

No other sources - just one Data Source in Data Source settings in the file. I even deleted all global data sources.

 

Workaround: Saved the file as a Template (.pbit), then republished to the service - seems to work and the on-prem source is correctly switched to SQL Azure.

View solution in original post

2 REPLIES 2
prihana
Helper V
Helper V

Hi,

 

Are there any other data sources in the report? Have you removed the onprem datasource completely from the PBI and uploaded it to the cloud?

sethsanu
Frequent Visitor

No other sources - just one Data Source in Data Source settings in the file. I even deleted all global data sources.

 

Workaround: Saved the file as a Template (.pbit), then republished to the service - seems to work and the on-prem source is correctly switched to SQL Azure.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors