Configuration OData to connect PowerBI

Franklin

Hi everybody,

I´m trying to connect my NAV 2016 Database with Power BI but always i have a credential error. Has somebody been able to connect it?


They could not update the data source credentials : Unable to connect to the data source . Ensure that the data source is accessible.
Hide details
Business Id . 024e8fa3-90ac - 44f3-9c45-6097dd355826
Application Id . 5,448,986th - 5d4c - ce0c - 676d - b964fcf832f9
Status Code: 400
Time: Tue November 3, 2015 11:37:22 GMT + 0100 (Standard Time Romance)
Version: 11.0.9168.508
URI cluster : https://wabi-north-europe-redirect.analysis.windows.net
Details: OData : Request failed: Unable to connect to the remote server




And why with the Demo NAV 2016 demo environment you can connect the Demo Querys but you can´t add custom Querys...

King regards,

Juha

I had a simular problem connecting powerbi to my nav2016 azure demo.
After disabling ssl on Odata and renaming the company to something simple like demo (was Cronus Danmark A/S) I got them connected.

Franklin

Thanks Juha.

But do you have got connect other database? I can connect Azure NAV 2016 demo but not, with another custom database.

mgmutha

Hi,

Go to NAV 2016 Administration Tool > Select Service > Click Edit > Go to ODATA Service Tab > Check mark on "Enable Odata Service" > Save > Restart Service and Check now.

Regards,
Manish Mutha