cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
S_M Member
Member

Error in dataset when publishing from pbix

Hi everyone,

 

 

I have noted that today people have faced some issues with the power-bi service so i am not sure if this is entirely related. 

 

When publishing from my pbix model, the sign marking 'publishing' in process goes on a loop - it does not give me an error/success even after an hour. However, on the power bi service i note that the 'last refresh' gets updated, and the data loaded is partially refreshed. I also see a sign against my dataset denoting that 'there was an error with my dataset'. It is frustrating as i have been trying to publish for the past couple of hours but have faced the same issue over again. Any idea why this may happen ? 

 

I have also faced the same issue a couple of times in the past but it either resolved on its own in a few hours, or i had to republish an older model with the same dataset name or sign-in/sign-out of my account. Any idea why this happens or how it can be resolved ? 

 

 

Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Error in dataset when publishing from pbix

@S_M You could always see if it's the PBIX file. Save it as a different file name and try to publish it. Worst case, you rebuild the dashboard and re-share...


Near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

6 REPLIES 6
Super User
Super User

Re: Error in dataset when publishing from pbix

@S_M Hmmm. They just pushed a Desktop update to add some functionality... Maybe try to get the latest version and try again? Otherwise, I do have older versions if you want to back up to a previous version. I could share a one drive location with those.


Near SE WI? Join our PUG Milwaukee Brew City PUG
S_M Member
Member

Re: Error in dataset when publishing from pbix

@Seth_C_Bauer, I am currently using 2.38.4491.282 64-bit (August 2016) - has there been an update since ?

 

If so, yes, i will do that else back up to an older version, if you could share it Smiley Happy 

 

Thanks alot!

Super User
Super User

Re: Error in dataset when publishing from pbix

@S_M Blog just came out today that they updated the inline drill down feature. You can get the latest from your Power BI Service.

New version is 2.38.4491.642

 

If that doesn't work and you want to back out to some other version, let me know, I have them all.

 

edit: include blog link


Near SE WI? Join our PUG Milwaukee Brew City PUG
S_M Member
Member

Re: Error in dataset when publishing from pbix

@Seth_C_Bauer, tried it with an updated version however this time, it gave me an error :

(FailedToRefreshPackageAfterImportError). 

 

I think it may be related to the PowerBI service. Can i replace the dataset online on the service ? Will it delete all the dashboards/reports created online ? 

 

Edit: I actually published another dataset and it published right away. I think it is a problem with this specific dataset, however i have made no changes to it in the past few days, so i am not sure what may be causing this 

Super User
Super User

Re: Error in dataset when publishing from pbix

@S_M You could always see if it's the PBIX file. Save it as a different file name and try to publish it. Worst case, you rebuild the dashboard and re-share...


Near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

S_M Member
Member

Re: Error in dataset when publishing from pbix

That worked! 

 

I renamed the dataset online and the pbix and the publishing ran just fine - this way, i didnt even have to re-create the underlying dashboards & reports. I cant believe this was such a straightforward solution

 

Thank you SO much for your help! Smiley Happy 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 105 members 1,452 guests
Please welcome our newest community members: