Forum Discussion

IncursioML1's avatar
IncursioML1
Helper I
4 years ago

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 ba...
Need Help
GilbertQ's avatar
GilbertQ
Super User
4 years ago

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?

IncursioML1's avatar
IncursioML1
Helper I
4 years ago

Yes this works when I push it using desktop and that on-prem gateway that uses SP Online List and also SQL Server On Prem through that gateway.

The problem seems to be literally only when the schedule refresh occurs in Power BI Cloud or if I manually refresh in the Cloud version.

There seems to be something happening on one or two of the tables in which there is a relationship and there are some LOOKUPVALUE DAX expressions that are used in the SharePoint Online dataset to the SQL Direct Query dataset.  

However, if I refresh the data on the Desktop it works fine, but anything on the cloud, manually or scheduled the dataset refreshes with no errors, but the visual won't load.  I don't want to have to manually refresh on the desktop and push to cloud to fix that problem.  I'll take a browse again to make sure maybe one of the DAX calculation is working with all the records from SharePoint.  I assume they did because of no errors on the desktop pbix file.