cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

SharePoint - Data source issues?

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,

1 REPLY 1
Highlighted
Community Support
Community Support

Re: SharePoint - Data source issues?

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

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors