Forum Discussion

gtrajesh's avatar
gtrajesh
Frequent Visitor
7 years ago
Solved

Oauth2 option for authentication not available

Hi guys, I have my data source as an excel file that is on our organisations one drive location. Using Power BI desktop I am able to connect to the location and load the data. But after I publish the ...
Reports
  • jeffshieldsdev's avatar
    jeffshieldsdev
    7 years ago

    Are you reformatting your Excel web URL? Like this: "You have to strip out the :x/r/ from the middle of the URL and the question mark and everything after from the end and then it'll work."

jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
7 years ago

Are you reformatting your Excel web URL? Like this: "You have to strip out the :x/r/ from the middle of the URL and the question mark and everything after from the end and then it'll work."

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    I've got the same issue execpt when I follow you advice I don't have the :x/r/ or the ? in my URL

     

    In my query edittor I have the following as my source:

    = Excel.Workbook(Web.Contents("https://(then my link url).xlsx"), null, true)

     

    Any ideas that can help me?

  • ashokpershad's avatar
    ashokpershad
    Advocate II
    7 years ago

    Thanks for this solution, it has been making me anxious from last many days.. Strange kind of error..

  • Mapica92's avatar
    Mapica92
    New Member
    1 year ago

    Very usefull, I solved the same problem with your solution! THANK YOU 😊🙏