Forum Discussion

RabihGerges's avatar
RabihGerges
Frequent Visitor
3 years ago
Solved

Power BI Published Project - Unable to Refresh - Missing Authentication Method

Hello, I am trying to refresh my published power BI project where my database is an Excel Online file, found under my organizational Microsoft account files and folders. When I try to refresh or sc...
Need Help
Tips and Tricks
  • TomMartens's avatar
    TomMartens
    3 years ago

    Hey RabihGerges ,

     

    You have to use OAuth2 to connect to your Web based Excel file. It requires you to provide your email (the same you use to login into Power BI Service), something like [email protected].

     

    Hopefully, this provides what you are looking for.

     

    Regards,

    Tom

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey RabihGerges ,

 

You have to use OAuth2 to connect to your Web based Excel file. It requires you to provide your email (the same you use to login into Power BI Service), something like [email protected].

 

Hopefully, this provides what you are looking for.

 

Regards,

Tom

  • RabihGerges's avatar
    RabihGerges
    Frequent Visitor
    3 years ago

    Thank you for the help TomMartens 😎

    Please note that we had to also remove the "x:\r:\" section from the links of the Excel Online files that we are using as data source for the OAuth2 authentication method to be accepted by PowerBI.
    Thought I'd mention it here for your reference!

     

    Many Thanks,

    Rabih