Odata connection

[Jeanxyz]

Hi, 

I am trying to import data into power bi using Odata. I have tested the url and credentials in web broswer which works well. 

But in Power BI, the credential always fails. I have use both Odata feed and Web import mode, none of them works. 

[Jeanxyz]

Hi Denis, 

Thank you so much for the post. I have followed the same Odata procedure as described in the post. We don't have single sign-on set up in SAP. So I'm not quite sure why it doens't work. I will check with a SAP specialist to figure out the reason. 

Regards, 

Jean

[selimovd]

Hey @Jeanxyz ,

there are a few things you have to consider when you try to connect to SAP ByDesign OData. For example if you are using single sign on you have to add saml2=disabled as a parameter to the URL etc.

Check the following blog post on how to connect in Power Query:

Using SAP ByDesign OData in Microsoft Power Query | SAP Blogs

As an alternative there is also a connector for SAP ByDesign:

SAP ByDesign Power BI Connector - CData Software

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd · Accepted solution]

Hey @Jeanxyz ,

could you check the blog post I proposed?

I'm curious if you could solve this issue 🙂

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic