Forum Discussion

mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
8 years ago

Something went wrong - recurring error updating dataset.

Several times now I've gotten an error updating 1 of my datasets.    What's odd, is I can rename the local file, upload - and it goes in fine as a new dataset.  It's just trying to update that erro...
Need Help
mmace1's avatar
mmace1
Icon for Impactful Individual rankImpactful Individual
8 years ago

Hi,

 

I don't use a data gateway.  I manually push out an update.

 

There are many data sources this file draws from:  SQL Server, the local file system, Salesforce, & Sharepoint.  Possibly others, if there are old disused queries in there I haven't removed.

 

So, this is a  local Power BI file that I refresh on my local computer, then click Publish to push out to the service.

 

It refreshes fine locally, and when I click 'Publish', everything appears to go fine after it asks me if I want to replace the existing dataset, eventually saying 'success'. 

 

But then checking the dashboard/report online, I see things hadn't actually updated.  So then checking the dataset online, I see that it has an error.

 

 

And agian if I publish the same file under a different name - it goes through fine as a new dataset.  It's just having trouble replacing the dataset.

 

Do I make sense?

 

 

 

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi mmace1,

 

What's the error message when you click the yellow exclamation sign? I can't reproduce it. I would suggest you file a support ticket here.

create ATicket

 

 

Best Regards,

Dale

  • mmace1's avatar
    mmace1
    Icon for Impactful Individual rankImpactful Individual
    8 years ago

    Hi,

     

    The quote up in my initial post has the error message in it.

     

    Thanks, unfortuntely I'm not actually a pro user (still on a trial), so I can't submit a support ticket without setting up payment (which would be even more of a hassle then getting myself on a proper license...and that's a hassle I'm not going to do at work until it's absolutely necessary).

     

    Obviously rebuilding my dash is a hassle too - but *most* days I can refresh the dataset fine.  e.g., since this began, I'm currently on the 3rd copy of my datasets (two of them do this now...).

     

     

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      Hi mmace1,

       

      I found a similar case in the internal system. Please @me when you want some updates. Did you try uploading the file from the Service? There is also a Replace prompt.

      something_went_wrong

       

      Best Regards,

      Dale

      • mmace1's avatar
        mmace1
        Icon for Impactful Individual rankImpactful Individual
        8 years ago

        Hi v-jiascu-msft,

         

        No I did not try uploading the file from the service - I didn't know that option was there, thanks!

         

        Coincidentally this morning though the issue came back, and I tried doing a fresh install of Power BI.  And now updating seems to be working...but that means I can't reproduce the issue today to see if uploading via the service can be a workaround.

         

        When/if this comes up again - the first thing I'll try is uploading via the service, thanks.