Forum Discussion
visual not loading
What could be causing this error below? The report loads fine in the desktop but then something doesn't work with the visuals in the cloud. I have to delete the dataset in cloud and then publish back every single time in order for it to work.
Is there something that's not loading properly on the calculated table?
4 Replies
Hi IncursioML1
Can you refresh the dataset and see what happens if it still fails after the refresh. The error appears that the calculated table is not in a processed state?
Ah yes, it does seem that it is failing on the refresh state.
The gateway is running on a physical machine that's on 24/7, in which I have 2 connections in the report.
The first is a SQL query to an on premise database, which appears to work with the connections.
The second one is a SharePoint Online list in which I had set it to OAuth type.
My guess is that it's the SharePoint one since a couple of those queries does some relationship mapping to the SharePoint Online List that gets brought in. What is the correct way to set up a SP Online refresh? Can this not be done on a On Premise gateway?
Hi IncursioML1
I would suggest creating a data source in the On-Premise gateway to your SP Online list, and then you can select it in the Gateway and it will all be refreshed together?
