cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBI-ELM
Helper I
Helper I

Trying to move the source of a report to a different Gateway/DataSet/DataSource

I am building a report for a customer and started by setting up a local copy of their SQL database.  I installed the on-Premise Gateway in Standard Mode, Power BI Desktop and was able to create a report and have it work when I uploaded it to the service.  Nothing unusual here.

 

I have just drove out the customer and setup the gateway on one of their machines.  In the Power BI Service, I can create a data source associated with the Gateway and it authenticates with the username and password.

 

I should point out that from my office I don’t have access to their SQL server directly so I cannot login to the SQL Server with Management Studio.  But I do have the Gateway access.

 

What I want to do is to either one of the following:

 

  • Take my existing test report and change it to use the other gateway
    1. Either using Desktop or the Service

Or

  • Create a new report / data set by using the other gateway / data source that I set up
    1. Either using Desktop or the Service

If I take my existing report on the Service and go into the settings of the dataset it allows me to work with the Gateway settings.  But it will not allow be to select a data source. It just says “Not configured correctly”.  It presents the original Data source definition (SqlServer{"server":"MyOwnServer","database":"thename"}) and wants to add it to the gateway.   The only available option “Add to gateway” does not seem to get me anywhere.

 

After a couple of hours of Googling and trying things, I am reaching out for help

 

Thanks

1 ACCEPTED SOLUTION
PowerBI-ELM
Helper I
Helper I

While I don't mind comments from others, did find a solution.

 

Instead of trying to change the data source for the published report in the Service, I created an alias on my local development SQL server to match the name of the target customer server.  Then using Desktop I directed the existing report to the new alias. When I published the updated report it was much more cooporative.

View solution in original post

2 REPLIES 2
PowerBI-ELM
Helper I
Helper I

While I don't mind comments from others, did find a solution.

 

Instead of trying to change the data source for the published report in the Service, I created an alias on my local development SQL server to match the name of the target customer server.  Then using Desktop I directed the existing report to the new alias. When I published the updated report it was much more cooporative.

Hi @PowerBI-ELM 

Thank you for sharing. Cheers!

 

Best Regards,

Community Support Team _Tang

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

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors