Forum Discussion
How to replace Data Source for existing report?
Anonymous In power bi desktop go to query editor, select your table and on the right hand side under Applied Steps click settings icon. You can also without going to query editor - go to File -> Options and settings -> Data source settings >Right click data sources and chnage source.
go into Edit Queries. Find the table/query you want to change. Go to the first step in the Query (always called Source) and change it there.
HI Gurus,
I have one report which is developed using Excel now I want to switch from Excel to MS-SQL. How can I replace the source as the steps suggested below is only for the same source. What about the cross data bases like Excel and SQL.
Read this article http://www.decisivedata.net/blog/change-a-power-bi-data-source-type this shows you how to do the change from Excel to SQL Server or to any other type. I tested it and it works fine.
You are amazing!
You solve my problem in a couple of seconds!
COOOL! Greate!
Thanks!