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 Odata feed and Web import mode, none of them works. 

 

 

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
     

3 Replies

  • Jeanxyz's avatar
    Jeanxyz
    Power Participant
    4 years ago

    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'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