Forum Discussion

nannimora's avatar
nannimora
Helper I
5 years ago
Solved

Change Data Source

Hi i need to change data source of my pbix. 

I have to switch from PostgreSQL to SQL. If i go to datasource settings i can only change server and database but i cant change the type (SQL, Excel, ecc.)

 

Someone could help me?

 

thanks

 

Regards

Need Help
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    nannimora Sure, create a new PBIX file that connects to your SQL data source. Open up Advanced Editor in Power Query and copy the Source and Navigation lines.  Now open a copy of your report that connects to the PostgreSQL database. Open Advanced Editor and replace the Source and Navigation lines with your copied Source and Navigation lines.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    nannimora Sure, create a new PBIX file that connects to your SQL data source. Open up Advanced Editor in Power Query and copy the Source and Navigation lines.  Now open a copy of your report that connects to the PostgreSQL database. Open Advanced Editor and replace the Source and Navigation lines with your copied Source and Navigation lines.