topic Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online in Report Server

How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Anonymous — Thu, 11 Mar 2021 14:53:05 GMT

Friends, I am preparing a dashboard for MS Project Online data which I believe a cloud datasource. Successfully completed creating the dashboard but unable to refresh the report from Power BI On-Premise Report Server since internet connection is not allowed in our Power BI Prod server.

Error Message: OData: Request failed: Unable to connect to the remote server
Contacted my server team - They said that they cannot configure system wide proxy due to security issues and they are asking if we can setup proxy for this specific application - Power BI Report Server?
May I know the right approach to setup proxy or to connect to cloud datasources from PBI On-Prem report server.

Kindly help.... 😞

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Anonymous — Fri, 12 Mar 2021 04:15:04 GMT

Guys any ideas please

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Anonymous — Fri, 12 Mar 2021 05:04:12 GMT

Error Message: OData: Request failed: Unable to connect to the remote server
Contacted my server team - They said that they cannot configure system wide proxy due to security issues and they are asking if we can setup proxy for this specific application - Power BI Report Server?
May I know the right approach to setup proxy or to connect to cloud datasources from PBI On-Prem report server.

Kindly help....

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Icey — Mon, 15 Mar 2021 09:22:33 GMT

Hi Anonymous ,

To my knowledge, this is not supported in Power BI Report Server. You can post your idea on Power BI Ideas forum. It is a place for customers to provide feedback about Power BI.

Here is a document about Configuring Power BI Report Server with Azure Application Proxy, but the aim is to access Power BI Report Server reports from client browsers and be protected by Azure Active Directory (AD) when users are away from the corporate network.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Anonymous — Tue, 16 Mar 2021 09:31:46 GMT

you mean it is not possible to create reports for cloud data sources from Power BI On Prem Report Server?

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Icey — Tue, 16 Mar 2021 09:43:53 GMT

Hi Anonymous ,

You can connect to cloud data sources in Power BI Desktop Optimized for Power BI Report Server.

But when you publish the report to Power BI Report Server, it is not supported to configure scheduled refresh for most of them. In other words, they are not supported in Power BI Report Server.

You can check the list of supported data sources in Power BI Report Serve here:

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Anonymous — Tue, 16 Mar 2021 10:24:55 GMT

Thanks Icey My datasource is MS Project Online and I used ODataFeed. As per the above link ODataFeed scheduled refresh is possible in on-prem report server and all 4 types of authentication is accepeted for model refresh. But I am able to refresh it in power bi desktop and when I tried the same in report server using windows authentication it is not accepting and says wrong ID / Password.

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Anonymous — Wed, 17 Mar 2021 06:08:16 GMT

Icey any suggestions for the above please

Re: How to config proxy to enable Power BI Report Server for accessing cloud datasets -MS Project Online

Chiniminiz — Mon, 20 Sep 2021 12:16:45 GMT

Hi BI_Analyticz,

You should try to set the Proxy settings directly in the user on the virtual machine, which runs the Power BI Report Server Configuration Manager. The user you set as Service Account should connect to the Server and set your Proxy Settings in Settings --> Network & Internet --> Proxy.

After you log out, restart the Server.

Then the Report Server should get access to through the Proxy.

If you use the virtual account as Service Account, create an User-Account which you may use.

Good luck and kind regards! 🙂

Patrick Struwe