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,
The source data of my report comes from three excel files. The data in these files will be updated periodically. These files are stored on SharePoint.
Here's the requirement.
To enable few other users so they can do the data entry in the three excel files, and then update the Power BI report.
Here's what's happening
After they edit and save the excels and click refresh on the report, the report does not update. They all have read, reshare, build permission on the dataset.
How do I achieve this?
Note that
Solved! Go to Solution.
Hi @Enigma ,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Any ideas?
Is it mandatory to have a gateway installed for this purpose? The files are stored on SharePoint.
Hi @Enigma ,
Would you please check the credentials and refresh history for it?
And you should refresh the dataset before you refresh the report:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks @v-deddai1-msft
Yes, there was an issue with the credentials. I reset them and the refresh started working.
I had a few more questions around this, though.
Thanks!
Hi @Enigma ,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
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.