SharePoint - Data source issues?

[lordtopcat]

Hi guys,

I have published a PBI report which gathers data from a SharePoint list. I can refresh the data in PBI Desktop and then publish it, however I want to schedule a refresh of the data in the workspace so I don't have to manually do it every morning.

I've tried using all 3 authentication types - Anonymous (our SP site does not allow anonymous connection at all), Windows and OAuth2. The only one I've managed to "connect" with is OAuth2.

However, when I do so - all my data disappears. My existing charts and tables etc go, but I can drag new data onto the page and it works? I don't want to have to rebuild the model online, so hoping someone may have a solution?

Cheers,

[v-shex-msft]

Hi @lordtopcat,

I'd like to suggest you to check the refresh history if it successed and share some detail informations about this issue.
In addition, if you manually refresh this dataset/dashboard, does these data appeared?

Regards,

Xiaoxin Sheng