cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nannimora
Helper I
Helper I

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

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors