Keep Relationship Model and visualizations changing the Data Source

Anonymous Thank you so much! I was afraid that solution would go in that way. I'm going to do a test with a draft file to train myself. To connecting to SQL data bases, do you recommend using DirectQuery instead of certified connectors? 

Thanks again! :)

Hi Anonymous ,

Before try to change the source of data in Power Query Editor, it is important to do a backup of entire pbix file.

You can open the Advanced Editor in Power Query Editor, then change the first several source query, and remove some step may occor error, like following pictures, I have a excel and sql database which have same data model, but excel have two empty column, after I change the source to SQL Server, I delete the steps because there are no this two columns in SQL database.

And you can refer the following document to learn more about difference between the DirectQuery and Import Mode.

https://docs.microsoft.com/en-us/power-bi/desktop-storage-mode

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

Best regards,

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

Hi Anonymous ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

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