Power Bi Data refresh - how to refresh NAV Odata feed as data source in power bi service .

[Anonymous]

Hi all,

I have designed the report using Microsoft Dynamics NAV 2018 Odata Feed . I authenticated that Odata using windows credentials in my power bi desktop. Now i publishesd the Report to power bi service.

I want to refresh in Power bi service , but when i try authenticate the odata feed using on - prem gateway .

I could not authenticate it. Please tell how to refresh this odata feed by authenticating in power bi service.

please Help me on this , its an urgent requirement

@Anonymous @Baskar 

Thanks,

valliappan

[v-yuezhe-msft]

@Anonymous,

What error message do you get? Generally, when connecting to Dynamics Nav in Power BI Desktop, we choose basic authentication, and  provide the user name (“User name”) and password(Web Access Key).

For more details, please review the following articles.

https://docs.microsoft.com/en-us/dynamics-nav-app/across-how-use-financials-data-source-powerbi
https://www.1clickfactory.com/blog/how-to-configure-power-bi-for-microsoft-dynamics-nav/

Regards,
Lydia