Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Odata dataflow - 'Invalid Credentials' for only a single Dynamics entity

Morning all!

 

I am currently setting up multiple dataflows to General Ledger data held in Dynamics NAV, via Odata feeds. In total, the client has 14 companies on Dynamics NAV with the same user credentials applicable across all.

 

I have successfully managed to set up 13 of the dataflows, however one of the companies is showing an 'Invalid credentials' error when trying to set it up.

 

I have tried replacing any '%' characters with the actual character (Eg. %20 with a space), however that yields the same result.

 

http://SERVERNAMEHERE.local:8048/NAV2017/OData/Company('Company%20Name%20Ltd')/BI_GeneralLedgerEntries

http://SERVERNAMEHERE.local:8048/NAV2017/OData/Company('Company Name Ltd')/BI_GeneralLedgerEntries

 

Does anybody know why one of the companies is giving this error when all the others have been fine?

 

Thanks in advance,

Ally

 

 

Dataflow
  • Anonymous's avatar
    Anonymous
    4 years ago

    After testing the Odata feed on Power BI desktop (and seeing it worked there), I went back into the Power BI service, went to 'Manage gateways', and removed the old data source which had been created (even though it never worked). When trying to set it up again, it worked this time.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    After testing the Odata feed on Power BI desktop (and seeing it worked there), I went back into the Power BI service, went to 'Manage gateways', and removed the old data source which had been created (even though it never worked). When trying to set it up again, it worked this time.