connecting Odata feed having token based authentication with Power BI without Advance Query Editor

Question

How can I get data from Odata feed to Power Bi and I want to secure it with SSO authentication,I have tried this and It is giving me the following error

Details: 

"OData: The given URL neither points to an OData service or a feed: 'https://SSOurl/Account/Login?ReturnUrl=/?wtrealm=https://actualOdataURl"

How can I resolve it? 

Answer 1

If you are not able to fetch data from Odata.feed then, add new blank query in Power BI Desktop, and use the following codes.

let 

Source = OData.Feed("URL", null, [Headers = [Authorization = "Bearer Your token" ] ])

in

Source

 and

let    

Source = Web.Contents("URL", [Headers=[#" Authorization  " = "Bearer Your token"]])

in

Source

If u want to learn the tool in-depth, then come to us and sign up for this Power BI Certification