Forum Discussion

Advocate I

3 years ago

Solved

Credentials provided for the OData source are invalid. (Source at https://api.security.microsoft)

Dear all, We have several dataflows that are conected to the MS API via an Enterprise Gateway and an oData Source. Three of them are connected to https://api.security.microsoft.com/api/xxxx . P...

Need Help

v-yueyunzh-msft
3 years ago
Hi , BrunoM

According to your error screenshot, the error message you are currently encountering is still an "invalid credential" error, so you can confirm that the credential you input for the datasource definition configuration is the same credential you entered when connecting to the data source and creating the data flow, and the privacy level is also consistent, if confirmed, you can put error The detail expansion is sent in text format here for further study.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

v-yueyunzh-msft

Community Support

3 years ago

Hi , BrunoM

According to my understanding of Power BI gateway, it is generally used as a bridge between Power BI Service and on-premises data sources, and you describe that you want to connect to some MS APIs through the gateway to configure data flow refresh on the service, which is also possible in principle. According to your description, you have a problem configuring the gateway connection to connect OData.Feed("https://api.security.microsoft.com/api/recommendations", null, [Implementation = "2.0"]) with the error: Credentials are required to connect to the OData source. For convenience, you can check if you can enter credentials for this data source by editing the credential directly in the datasource credential. Can skipping the gateway level avoid this error?

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

BrunoM
Advocate I
3 years ago
Hi Aniya,
Thank you for your message.
You propose to skip the gateway: In fact, as you can see in the screenshot, those sources do not use the gateway

They are identified as a connexion in the gateway admin portal but they do not use the Gateway cluster and software.

Trying to redo a complete setting of this connexion, i have removed it from the Gateway admin portal then à i recreated it throught the dataflow :

Result : Same error message in the dataflow power query interface.

Trying to update the connexion in the dataflows settings tab :

Changing Private into organizational then sign in :

Best regards, Bruno
- v-yueyunzh-msft
  Community Support
  3 years ago
  Hi , BrunoM
  
  According to your error screenshot, the error message you are currently encountering is still an "invalid credential" error, so you can confirm that the credential you input for the datasource definition configuration is the same credential you entered when connecting to the data source and creating the data flow, and the privacy level is also consistent, if confirmed, you can put error The detail expansion is sent in text format here for further study.
  
  Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
  
  Best Regards,
  
  Aniya Zhang
  
  If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
  - AlinaYakymchuk
    Frequent Visitor
    3 years ago
    Hi BrunoM ,
    
    I would really appreciate it if you could share any details how fix it?
    I have the same problem with OData feed connection.
    
    Thanks,
    Alina