topic Report Server - API Data Source Connection Issue in Report Server

Report Server - API Data Source Connection Issue

Anonymous — Wed, 17 Jun 2020 18:02:03 GMT

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?

Re: Report Server - API Data Source Connection Issue

d_gosbell — Thu, 18 Jun 2020 00:51:49 GMT

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.

Re: Report Server - API Data Source Connection Issue

chrisbrigg — Mon, 29 Jun 2020 18:45:38 GMT

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.