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

Problems replacing datasets

Hi all,  I'm having troubles replacing an existing data set using PowerBI Desktop.  It says the dataset is being successfully uploaded, but when it starts to refresh it's still using the old one. I've tried to upload a copy to see what happens, and it works just fine.  Appreciate your help here.  Thanks Ben

1 ACCEPTED SOLUTION

Accepted Solutions
sebbayard
Frequent Visitor

Re: Problems replacing datasets

Thanks for all your input.

I think I finally managed to resolve the issue by checking off all your points together with the input from this thread: https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-lt-ColumnTitle-gt-of-the-table-...

 

Cheers

Ben

View solution in original post

3 REPLIES 3
JBJ2110
Frequent Visitor

Re: Problems replacing datasets

Hi,

 

I might be barking up the wrong tree, but here are some thoughts based on my own (albeit limited) experiences:

1) Are you trying to upload a dataset that has the SAME NAME, but you have changed something in the original dataset? If the answer to this is yes, make sure you save changes on BOTH the Excel side and the Power Pivot side. I have found that there are times when I have made changes to tables in Excel, but DID NOT go over to the Power Pivot side and save there as well. When I tried to refresh to Power BI, it didn't see the changes. Also--you need to make sure you refresh the tables in the Power Pivot data model as well. 

2) I have noticed that when I am saving my changes to a Sharepoint site (I am using a O365 Sharepoint), there is sometimes a delay in that save process. Look in the bottom right hand side of your screen to make sure it is showing that it is saving to your designated location. 

3) I believe that the NAME of the original file is critical. I don't change the name of my dataset because the connection between Power BI desktop and Excel will NOT pick up the changes in the file with the new name. 

I am sure that others, with more experience, may be able to add more/different comments that will be helpful to you. Meanwhile, I hope this helps. 

Jessica Jolly
Alt-Enter, LLC
Building digital skills, bit by byte
www.altentertraining.com
Microsoft v-haibl-msft
Microsoft

Re: Problems replacing datasets

@sebbayard

 

While you publishing to Power BI, did you receive a message said that “You already have a dataset named ‘***’ in Power BI. Do you want to replace the existing dataset with this one”?

If yes, the dataset on Service should be replaced with this new one. If no, please check that if you changed the name of old one in Service (e.g. add a blank which cannot be easily noticed).

 

One more thing, did you publish the new one to the same group as the old one? If you publish to a different group, the old one will not be replaced (e.g. the old one is in My Workspace and the new one is published to another test group)

 

Best Regards,

Herbert

sebbayard
Frequent Visitor

Re: Problems replacing datasets

Thanks for all your input.

I think I finally managed to resolve the issue by checking off all your points together with the input from this thread: https://community.powerbi.com/t5/Desktop/Expression-Error-The-column-lt-ColumnTitle-gt-of-the-table-...

 

Cheers

Ben

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors