Forum Discussion

scottrmeredith's avatar
scottrmeredith
Frequent Visitor
2 years ago
Solved

Different Errors on each refresh in Desktop

A spelling error was corrected on a field in one of my data sources so my online scheduled refresh failed.  I opened my report to update it in desktop and when I try to refresh the data in desktop, I...
Need Help
  • scottrmeredith's avatar
    scottrmeredith
    2 years ago

    So what I ended up doing to fix it was download the PBIX file from the online service and then ran the refresh and updated the fields that had the spelling change.

Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

Hello scottrmeredith ,

 

what i would do is that i go to power query and try to refresh every table alone to see where is the error is coming from and then solve the issue.

  • scottrmeredith's avatar
    scottrmeredith
    Frequent Visitor
    2 years ago

    So I went table by table in the power query editor and refreshed each table by either clicking the refresh button if it displayed or the Refresh Preview button if it did not.

     

    One table did give me the following error when trying to refresh the preview, but I did it a second time and it refreshed fine.

     

    So then I did refresh from the vidual editor screen and got this error message.

     

    So I went back into transformations and re-did the preview refresh on that table and tried the overall refresh again.  The second time I get the same error, but on a different child referenced table.

     

     

     

    • scottrmeredith's avatar
      scottrmeredith
      Frequent Visitor
      2 years ago

      I have also tried to clear the permissions for the data sources and re-connect.  Same error, just a different child referenced table from Dataverse.