cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
zzsuffa Advocate I
Advocate I

Re: How to replace Data Source for existing report?

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.

chfio
Regular Visitor

Re: How to replace Data Source for existing report?

Hi.

I am trying to change my source from local tsv to a url tsv. 

I see in editing source i can change the file but it seems I'm not able to change to a URL (as I am able in the initial get data window).

 

*not able to download too large for HD

*Recreating the query and subsequent table edits would be .. not ideal.

= really hoping to seamlessly point the existing steps + report to a URL source instead of current local file upload:)

 

BastiaanBos
Regular Visitor

Re: How to replace Data Source for existing report?

Did you find a solution for your issue ? I'm trying to edit the source from a TEST environment Odata source to a PROD environment Odata. 

 

moredvikas
Frequent Visitor

Re: How to replace Data Source for existing report?

We went into Edit Queries and clicked on Data Source settings and we were able to change the SSAS sever name. 

sanjupanda
Regular Visitor

Re: How to replace Data Source for existing report?

How to replace the data source of the report when we move from one environment to the other (e.g:  from Dev to Test) ?

sanjupanda
Regular Visitor

Re: How to replace Data Source for existing report?

Hi All,

 

How to update an existing powerBI report when the datasource changes from DEV to TEST ?

Shelley Responsive Resident
Responsive Resident

Re: How to replace Data Source for existing report?

Hi, Are the field names the same? If so, what I've done to make this easier and it seemed to work, is:

1. In Edit Queries, I added the new source table.

2. Then I clicked on the new source table, and then clicked Advanced Editor.

3. In the new source's Advanced Editor pane, I copied the commands with CTRL-C. Clicked Done.

4. Then I clicked on the old table, and clicked on Advanced Editor, selecting all the commands here, and then pasted the new source information using CTRL-V.

5. When you apply the changes, this should point your old query to the new source, and you should actually be able to delete the new table you added as it will now appear twice.

Please NOTE: you have to take care here if you performed any transformations. You may have to repeat them or edit the commands accordingly.

I hope this helps. Everyone's situtation and environment is different, so perhaps this may or may not work for you.

KoalaPandaSloth
Frequent Visitor

Re: How to replace Data Source for existing report?

This worked. Thanks 

Shelley Responsive Resident
Responsive Resident

Re: How to replace Data Source for existing report?

Did you follow the steps exactly? Did you receive an error? I've done this several times now, always with success. Are all the column names the same? If a column name is different, the existing expressions using the different names will not automatically connect to the new data.

 

 

ffro3
Frequent Visitor

Re: How to replace Data Source for existing report?

This worked flawless for me!

 

Thanks a lot!

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors