Authenticating credential error when refreshing merged table with OneDrive excel files

[ysherriff]

Hi all, I have 5 excel files that are linked to Power BI from OneDrive and I appended them into one table… See image #1 for the files and image #2 for file path. The file path is online, so that is correct. I also authenticated with OAuth2. See image # 3.

But the issue is that I have the appended file merged to a different table but it fails when refreshes. See image # 4. I disabled the merged table and refreshe the OneDrive files by themselves and it worked. I then disabled the onedrive files and tried to refresh only the merged table and it fails. The issue is with the merged table. What am I doing wrong? Thanks for your input and help.

[Anonymous]

Hi @ysherriff 

It's working fine on Desktop, but on Service, there's a problem now, right ? Did you check the URL in Service ? You can update your credentials in Data Source credentials to see whether you can refresh the dataset .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ysherriff]

I have tried it in the desktop rather than the service and it worked. Thanks