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
Icon for Solution Sage rankSolution 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?