Forum Discussion
IamTDR
Responsive Resident
Responsive ResidentBI Report Refreshes on Desktop / Error Refreshing in Service
Hello As the subject line states, I created a report via BI Desktop and when I publish the report to BI Service the report does not refresh. I am receiving a error message that I do not understan...
I just got my BI report to Refresh in BI Service.
I think this must be a bug.
In my table, I used a transformation (Power Query) to sort by date. By removing the Sort step the report was then able to refresh in Service. (In reviewing, the Sort step wasn't actually needed)
Not sure why Sorting caused this issue, but this was how I resolved my issue after many trial and errors.
In my case, I deleted all the sorted rows and left the Appended Query to the end of steps