cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Replace Data Source?

Hey,

 

Im using an excel file (with pivotmodel) as an data source for my Reports in Power Bi. Scheaduled data refreshes through Personal Gateway works fine but problem arises when i do changes to the pivot model (adds a table). The table doesnt show in Power Bi when i refresh the data source (But data is updated).

 

My first idea was to replace the data source with the "new" updated one but doest seems to work ,just get two data sources with the same name. Best practice would be......?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resolver I
Resolver I

Re: Replace Data Source?

The following link has the instructions for replacing an existing file. There are also additional Notes on structural changes and how Power BI handles them. 

 

https://support.powerbi.com/knowledgebase/articles/655108

 

View solution in original post

8 REPLIES 8
Highlighted
Resolver I
Resolver I

Re: Replace Data Source?

The following link has the instructions for replacing an existing file. There are also additional Notes on structural changes and how Power BI handles them. 

 

https://support.powerbi.com/knowledgebase/articles/655108

 

View solution in original post

Highlighted
Frequent Visitor

Re: Replace Data Source?

The link doesn't work anymore.. Does anyone know how to solve this?

Highlighted
Frequent Visitor

Re: Replace Data Source?

The link does not work, does you know how to solve this?

Highlighted
Frequent Visitor

Re: Replace Data Source?

Highlighted
New Member

Re: Replace Data Source?

Thanks - that does it.  Too bad there doesn't seem to be an easy way to change a connection en masse - for instance, if you import a bunch of Access tables and then change the location of the Access file - seems like you have to either individually edit each query, or start over.

Highlighted
Regular Visitor

Re: Replace Data Source?

That link doesn't go to any specific page, but instead redirects to a support welcome page (for me as a user in the UK, it's redirecting to a en-us support landing page).  

Highlighted
Frequent Visitor

Re: Replace Data Source?

Here is a screenshot of what I see when I follow the link for a working solution

Capture.PNG

Highlighted
Regular Visitor

Re: Replace Data Source?

Thanks chicUser 🙂   

 

That's a helpful page indeed!

The one that's marked as the 'accepted solution' too knowledgebase/articles/655108 is the link that doesn't work for me. 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.