Forum Discussion
Visualisations show blank on data refresh - SharePoint List
Having the same issue
HI there,
I managed to fix this myself. The data i was referencing was collected from an app that had a Yes/No selection, so boolean data. The way i fixed it is that in PowerBI Desktop, I went into 'Edit Queries'. Once in there, select the data column you are having issues with and go to "Data Type" in the upper right hand side of the ribbon. From the dropdown, select the appropriate data type (the default selection seems to be 'any'). The column will update (you'll know it's worked because the data will be in italics). From there, the refresh should work fine. For some reason, if the data type isn't selected correctly for some data types, PowerBI is unable to pull the data through the gateway. Hope that helps fix your problem.....
C