Forum Discussion

mariaHad's avatar
mariaHad
Regular Visitor
7 years ago

OData from different databases

Hello,   I am trying to get data from two databases in the same report. I am using oData as source. However, when I am going to edit the data form one of the two databases the other one is diconnec...
Need Help
mariaHad's avatar
mariaHad
Regular Visitor
7 years ago

Anonymous,

Thank you for your response. 

 

I am connecting to the databases with Basic method. I am adding the credentials and can edit the data of each one successfully. I don't receive any error message while I am adding the credentials. However, I can edit the data of only one database at a time because the other one is disconnected. The error message I received is: " We couldn't authonticate with the credentials provided. Please try again. -Edit Credentials-  ". I am editing the credentials of this database and the other one appears the same error. So I could not edit the data of both databases, at the same time, in a new query. (I have two different oData from different databases and I would like to create a new query with data of both of them)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

mariaHad,

What OData URL do you use? Is there any dependency between the two URLs? What is the result if you start a new PBIX file?

Regards,
Lydia

  • mariaHad's avatar
    mariaHad
    Regular Visitor
    7 years ago

    I am using OData from live environment of two different companies with no depedency between them. I tried to clear the permissions of the Data source and edit them again (from Data source settings). Now they look good. Thank you very much for your help!