Forum Discussion

ysherriff's avatar
ysherriff
Resolver II
3 years ago

Authenticating credential error when refreshing merged table with OneDrive excel files

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.

 

 

 

 

 

 

 

Need Help

2 Replies

  • ysherriff's avatar
    ysherriff
    Resolver II
    3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.