Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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
Solved! Go to Solution.
@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.
@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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.