Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
But when I go to the data view and trigger the refresh directly on the table:
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!
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.
Hi @InvCs
If the datasource is SharePoint List, after you publish the report to Service, go to dataset settings, then
(1) set credentials
(2) set Schedule refresh
(3) limitations
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |