Cannot refresh data from sharepoint

[afiqhaziq]

Hi, 

I have 2 files of report that connect to more than 10 list in sharepoint. It worked perfectly for more than 5 months. However, starting last friday an error like below came out.

Until now, the problem has not been resolved and i have no idea on what to do. I really need help.

[Anonymous]

Hi @afiqhaziq ,

Regarding your issue, when you try to refresh you get an error code 409, you can try the following:
1. Re-create the site on sharepoint and test the connection for success
2. If the connection is successful, check if recent file changes at the site have caused conflicts, and check if the sharepoint permissions configuration has been changed.
3. Use the connector that comes with sharepoint in power bi desktop to check if you can connect successfully, and if you fail, use Fillder to capture the cause of the error.
The specific articles are as follows:

Power Query SharePoint folder connector - Power Query | Microsoft Learn

4. Accidental error

[afiqhaziq · Accepted solution]

Hi @Anonymous ,

Thanks for the reply. Starting today my power BI suddenly become OK, all my data can be refreshed. Eventough, im not doing anything though. 

[afiqhaziq]

Currently im using API version 14. I noticed that when I change API version to 15. It can be connected, but then I have to remap and transform all the data over again. Also when im using API 15, the date got late 1 day behind which is the main reason im using API 14. Anyone can help. Please