Forum Discussion
Report Server - API Data Source Connection Issue
Hi,
I have May 2019 version Power BI Desktop and Report Server. Using OData feed , I created a dashboard pulling CRM data , but the same authenication doesnt work in Report Server Data Source connection.
I have Anonmyous, Basic , Windows and Key Authentication Type as options. The windows authenication doesnt work with the D365 credentails that I used in Desktop and I couldnt do scheduled refresh.
When you develop reports locally with PowerBI Desktop you have to use ‘Organizational account’ authentication type and sign in with your D365 credentials to pull API data. Do Power BI Report Server have OAuth authentication type to pass this type of credentials to the D365 API?
2 Replies
Anonymous wrote:
I have Anonmyous, Basic , Windows and Key Authentication Type as options. The windows authenication doesnt work with the D365 credentails that I used in Desktop and I couldnt do scheduled refresh.
Unfortunately as listed here https://docs.microsoft.com/en-us/power-bi/report-server/data-sources Dynamics 365 (or any other data source using OAuth) is not supported for scheduled refresh on Power BI Report Server.
Hello, is there a workaround or fix identified for this? It is a serious roadblock for those using Power BI Report Server on-prem with Odata sources.
