cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
InvCs
New Member

Report refresh from Sharepoint list not working propperly

Hi community, 

 

So I am facing a strange refresh behaviour in PowerBI desktop when trying to refresh from a sharepoint list. 

 

 

The normal refresh basecally works fine. It triggers all tables to refresh and runs trough smoothly.

However the data is not changing altough the sharepoint list was updated multiple times.

 image.png

 

But when I go to the data view and trigger the refresh directly on the table: 

image.png

the refresh is wokring and the updated data gets loaded. 

 

Main problem is, that when I publish the report to PowerBI Service and trigger a refresh on the dataset, nothing happens, similiar to PowerBI desktop. 

 

 

Anyone has an idea what could be the problem here ? 

 

Many thanks in regards!

 

 

 

4 REPLIES 4
v-xiaotang
Community Support
Community Support

Hi @InvCs 

Have you solved this question? Could you accept my answer as solution? To help others find it quickly. Thanks.
If you still have question, please let me know.

 

 

Best Regards,

Community Support Team _Tang

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

v-xiaotang
Community Support
Community Support

Hi @InvCs 

If the datasource is SharePoint List, after you publish the report to Service, go to dataset settings, then

(1) set credentials

vxiaotang_0-1637573480220.png

vxiaotang_1-1637573506289.png

(2) set Schedule refresh

vxiaotang_2-1637573526286.png

(3) limitations

vxiaotang_3-1637573604869.png

 

 

Best Regards,

Community Support Team _Tang

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

AlexanderPrime
Resolver III
Resolver III

Have you checked if the credentials in Dataset Settings need to be re-entered on the PowerBI publishing service? Sometimes when publishing a new Sharepoint connected database to web I find it doesn't bring the SharePoint credentials through correctly so needs a quick sign in. 

Thanks for the quick reply!

So after publishing, I had to enter credentials on the dataset again. 

The refresh is then basecally working , but data does not get refresh at all.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May 23 2022 episode 5 with aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt will talk about the importance of Data Modeling.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!