Hi PBI Community,
I have a workflow that creates a CSV on a user's desktop which is sync'ed via OneDrive to a SharePoint documents folder. The PBI service then uses this CSV as a dataset to populate a report. However, I ran into a sync error with OneDrive which required the deletion of the file. I guess the PBI service went to refresh when the file wasn't present and is now stuck on a OneDrive for Business sync error. The file is now present and has been for several weeks, but PBI Service will no longer refresh the file when clicking refresh. I teied deleting the dataset in PBI (which requried deletion of the report) and recreated the dataset and report in the PBI service, however it's still not refreshing. Below is the error code. Any assistance you could offer would be greatly appreciated!
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 8abf442a-dc76-4e96-b0ee-52c7da8f8aa3
Request ID: 91be9e09-9c50-4917-b027-af0599cde417
Time: 2020-02-24 16:54:26Z
Solved! Go to Solution.
Thanks for the reply; that explains it pretty well.
I wish it was a bit more intuitive (or troubleshootable) from the Refresh tab. It implies it's looking for a filename, not an identifier, and offers little in the way of solving errors.
I guess I am confused on the definition of the App Workspace. The dataset and report are contained in the Workspace for the SharePoint team that hosts the .csv file.. is that not in the Workspace?