Forum Discussion
An error occurred within the report server database. SSRS PowerBI Pin
Hi snamuth,
Firstly, please check if "the user performing the Power BI integration needs to be a member of the Azure AD tenant, a Reporting Services system administrator and a system administrator for the ReportServer catalog database". Also you can check other requirements listed in this article: Requirements for Power BI Integration.
Then please use the My Settings page to manually sign in to Power BI then pin the report. For more information, please refer to this article: My Settings for Power BI Integration (web portal).
The error "System.NullReferenceException: Object reference not set to an instance of an object" can be caused by many factors. In your scenario, have you installed any other SQL Server 2016 edition in the same server before? Please make sure all components are the same edition.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
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?
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