Forum Discussion

snamuth's avatar
snamuth
Frequent Visitor
10 years ago

An error occurred within the report server database. SSRS PowerBI Pin

I am having trouble pinning visuals from our SSRS 2016 to Power BI. I have registered the report server with Power BI, however, when I am on a report and try to pin to Power BI, I get the pop-up to s...
Need Help
snamuth's avatar
snamuth
Frequent Visitor
10 years ago

Hi Qiuyun,

 

Yes I have checked all of these requirements and they have been met. The Report Server has been registered for Power BI. The issue is when I run a report on the report manager and try to pin a visual to Power BI. I am able to login via the pop-up screen after clicking "Pin to Power BI" but then it just sits there and I get the error message. I think it may have something to do with the firewall settings on the Report Server. Are there certain inbound ports that need to be opened on the Report Server?

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi snamuth,

 

You can check which port is used by report server. Please open Reporting Services Configuration Manager, check TCP port in Web Service URL tab like below.

 

 

Then you can allow this port in firewall Inbound Rules to see if issue can be fixed. If issue persists, I would suggest you repair the SSRS by start SQL Server setup.exe and choose Repair on Maintenance tab.

 

Best Regards,
Qiuyun Yu