Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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

 

 

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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

       

  • peter-deagon's avatar
    peter-deagon
    New Member
    3 years ago

    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.