Can't data refresh automatically

[JohnnyTaiwan]

Hi all experts.

I am a new in power bi and make this for our company.

But I do have an issue on failed to data refresh.

The credentials provided for the Web source are invalid. (Source at https://web.sharepoint.com/sites/web-UIR/filename.xlsm.). The exception was raised by the IDbCommand interface. Table: ADV.

Some other setting as below

1. Two source data are in different sharefolder and use personal cloud connect for gateway

2.  Gatway :shows you don't need a gateway for this semantic model, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect. 

3. Data source credentials : Some credentials aren't validated as they are set to skip test connection.

4. Parameters : Parameters haven't been defined for this semantic model yet. If you want to set parameters, use the Query Editor.

[Anonymous]

Hi @JohnnyTaiwan ,

1. Try clearing the credentials and then re-entering them.

2. Confirm that you are using the correct authentication method required by SharePoint.

SharePoint and OneDrive for Business files import - From the Web connector using a file URL

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[Omid_Motamedise]

Make sure your account has access to both sources.