Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

How to replace Data Source for existing report?

how can i replace data source for existing report?
Need Help
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    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.

     

  • MattAllington's avatar
    MattAllington
    10 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

I found it's easy to go 'Edit Queries', then at your 'applied steps' double click 'Source' to browse and re-select the file. 

sandeepk66's avatar
sandeepk66
Advocate I
8 years ago

Can we Switch from SQL Server to Oarcle or an EXCEL? The reason, When I tried to change Source in the Source window gives SQL Server database, which is currently being used and can change to another  SQL Server database but not an excel or other Database.

and similarly When I tried to  Switch from  EXCEL based Power BI to SQL Server database ,it gives Source window gives EXCEL file path.