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.
GilbertQ
Super User
Super UserHi IamTDR
That is really weird what happens if you try it again?
Also is it possible to monitor your SQL Server when it is refreshing to see what query is being sent?
IamTDRResponsive Resident
Responsive ResidentTried multiple times during the day all the same results. Curious what happens after a refresh over night.