CODEWITHSUNDEEP
.netasp.net-web-apiodatapowerbi
Ganesh Londhe
Ganesh Londhe

Reputation: 161

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

Thanks in Advance,

i am trying to get the data from Odata Feed to Power BI, my Odata feed is secured with SSO authentication i.e. when i tries to access the data URL in chrome it redirects me to the login page and once i logged in successfully it redirects me to the result of the Odata service.

But some how in the Power BI i am trying to access the same URL it gives me below error: 

Details: 

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

i know it is redirecting to the SSo login server and due to that this error is coming.
below window i am using to fetch the data.

https://i.sstatic.net/zv9Og.png

it ask's me for the Authentication type but SSO type is not present in the Authentication types.

i also know that my Odata service work with Token also so i tried with Advance Query to get the Result like as below: 

let 
Source = OData.Feed("myOdataURL", null, [Headers = [Authorization = "My token" ] ])
in
Source

but i don't want to use the advance Query.


so what changes i'll need to do in my Odata service to get the correct result, without redirecting it to the SSO login server.

Upvotes: 3

Views: 2288

Answers (1)

bkwdesign
bkwdesign

Reputation: 2097

UPDATE:

Ignore the below answer. This is for creating a custom app or api that can connect and interact with existing Power BI datasets.

ORIGINAL:

I think you need to create an 'app registration' in your Azure Active Directory / azure portal app registrations to represent the Power BI desktop or Excel add-in. They have a quick way to get it up and running here

Then, you give THAT app-registration access to your Web API app-registration via the azure portal, and hit the 'Grant Permissions' button

Detailed walkthrough here: https://learn.microsoft.com/en-us/power-bi/developer/register-app

Will let you know if I succeed.

Upvotes: 0

Related Questions