Forum Discussion

Jeanxyz's avatar
Jeanxyz
Power Participant
4 years ago
Solved

Odata connection

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 O...
Need Help
  • selimovd's avatar
    selimovd
    4 years ago

    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
     
selimovd's avatar
selimovd
Most Valuable Professional
4 years ago

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
 
  • selimovd's avatar
    selimovd
    Most Valuable Professional
    4 years ago

    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