Different Errors on each refresh in Desktop

[scottrmeredith]

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 keep getting different errors that jump around to different data sources.  I have tried to only refresh my parent data sources and disable refresh on all my referenced child tables, I have two data source types, one is Dataverse and one is SQL.  Anything with prms as the prefix is SQL, and anything SB2 is Dataverse.  I was going to try to disable loading the data, but that would have broken my visuals on the pages it warned so I haven't tried that yet.

[scottrmeredith · Accepted solution]

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.

[scottrmeredith]

I have had this issue repeat 2 more times since I found a solution to this, and my solution did not work the subsequent times.  I did get it to work one more time by using my personal computer and ISP, but that did not work again the 3rd time I encountered the error.

[Idrissshatila]

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]

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]

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.