We are running SQL SSRS 2016. We tried installing Power BI Report server on the same server. The new install worked and I could run all my existing reports, but when I went to look at existing subscriptions on SSRS reports, the server returns a generic error and the subscription doen't exist. Here are the steps we followed.
At this point we could access the Power BI Report Server and all our folders, datasources, reports were in tact, as we would expect. The only thing that was missing is our SSRS subscriptions. I understand that Power BI reports cannot be put on a subscription, but what about the existing SSRS reports and their subscriptions, why are these gone? We had to rollback the upgrade because of this.
Solved! Go to Solution.
For anyone else who might run in to this. Make sure you add your email setting to the new configuration. When you don't add your email settings, the subscriptions won't appear in report server. Add in your email configuration in the configuration manager, restart the server, and the subscriptions will show up again.
For anyone else who might run in to this. Make sure you add your email setting to the new configuration. When you don't add your email settings, the subscriptions won't appear in report server. Add in your email configuration in the configuration manager, restart the server, and the subscriptions will show up again.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
5 | |
3 | |
1 | |
1 | |
1 |