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

[Anonymous]

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_GeneralLedgerEntri...

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

[Anonymous · Accepted solution]

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.