2

Just upgraded an existing instance of SQL Server 2014 to 2016. That instance has an instance of Reporting Services installed. My end goal is to connect Power BI Desktop (March 2018) to my existing report server. I've downloaded and installed Power BI Report Server. Worked through the reporting services configuration manager.

In Power BI Desktop, I try to pass my existing url to the Power BI Report Server Selection pane. The url that i'm passing is pulled straight from the config manager and I can connect to it using IE. Current error reads: "We couldn't find a Power BI Report Server at this address"

I've restarted the the service on my windows box, still no luck. Any ideas?

user9666467
  • 21
  • 1

2 Answers2

0

yes, it is possible and I am using it on my organization.

Just one tip: to deploy reports, we need to provide the Report Server URL (by default /reportserver) but on Power BI, we need to provide the report manager URL (default /reports).

Evandro
  • 868
  • 5
  • 12
0

In order to get Power BI Desktop to find my ReportServer, I had to grant OS level permissions to the user account opening Power BI Desktop.

This doesn't solve hosting pbix and rdl's on the same URL. Also, a gateway has to be set up in order to get scheduled refreshes working.

user9666467
  • 21
  • 1