Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to change Data source in Power Bi service

HI Team,

Myquestion:How to change datasource in Power BI Service( I know how to change datasource in Power BI desktop) I need how to change in Power Bi service

I database is Azure database

Previous Have Dev server now my report I need move to Prod server(both are Azure sql server database)

 

I am changing my Datasource servername and I am unable edit my server name

 

steps I am follow:

step1:Workspace-->ReportName-->datsets

Steps2:Then clinking Exclips(3 dots selected(Schedule and related view) then list display

step3:Selected "Setting"

Step4:Selected datasource credentail here edit credential

step5: then below image display display

 

 

 

Configure datasource.PNG

1 ACCEPTED SOLUTION
v-cherch-msft
Employee
Employee

Hi @Anonymous 

We cannot change data source of a report from Power BI service.Below is the post for your reference.

https://community.powerbi.com/t5/Desktop/Changing-Data-Source/td-p/497753

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
peter-deagon
New Member

When needing to change SQL server details and you are connecting to the SQL database via an On-premises Data Gateway, the best way I have found to do this is:

  1. Download the dataset from Power BI online as a .pbix file.
  2. Open the file in Power BI desktop.
  3. Go to File > Options and settings > Data source settings.
  4. Ensure that 'Data sources in current file' is selected, choose the data source the needs to be changed, then click Change Source.
  5. Update the server and database name as required and click OK.
  6. Click Edit Permissions and enter the relevant credentials. Click Save and OK.
  7. Close the Data source settings window.
  8. You will be prompted that there are pending changes. Click Apply changes.
  9. Click Publish. You will be prompted to save. Click Save.
  10. Choose the Power BI workspace that your data source is in.
  11. You will be prompted to replace the dataset. Click Replace.

The changes will be published to Power BI online. You may need to re-map the data source in Gateway connections.

v-cherch-msft
Employee
Employee

Hi @Anonymous 

We cannot change data source of a report from Power BI service.Below is the post for your reference.

https://community.powerbi.com/t5/Desktop/Changing-Data-Source/td-p/497753

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi team,

But when we have onpremies database we using Data Gateway  we can change data source.

but when we have Azure sql server we can change?

 

my table structure same i have only changing server name and database name/

.

 

Thanks

Shanvitha

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors