topic Re: Power BI Report Builder and SSRS Report Manager in Report Server

Power BI Report Builder and SSRS Report Manager

Anonymous — Wed, 05 Aug 2020 04:34:23 GMT

Hello,

I would like to build a paginated report with Power BI Report Builder using a shared Power BI dataset, and then publish the paginated report to an SSRS Report Manger. I get the following error message when trying to run the report on SSRS Report Manger 2016 or Power BI Report Manager 2017.

An error has occurred during report processing. (rsProcessingAborted)

An attempt has been made to use a data extension 'PBIDATASET' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

Do I need a higher version of SSRS Report Manager?

Any help is appreciated.

Thanks!

Re: Power BI Report Builder and SSRS Report Manager

KBO — Wed, 05 Aug 2020 05:06:00 GMT

Hi Anonymous

May be this link will help https://www.sqlshack.com/sql-server-reporting-services-ssrs-shared-dataset/#:~:text=In%20the%20SQL%20Server%20Reporting,multiple%20reports%20to%20retrieve%20data.

Also a tool update helps in most cases :).

Best,

Kathrin

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

Re: Power BI Report Builder and SSRS Report Manager

saglamtimur — Wed, 05 Aug 2020 06:21:01 GMT

SSRS currently does not support shared Power BI datasets. Yes, you can connect via Power BI Report Builder, but can not publish.

If my post solved your problem, mark my post as a solution to help others to quickly find it and also please give it a 👍

Re: Power BI Report Builder and SSRS Report Manager

Anonymous — Wed, 05 Aug 2020 11:58:37 GMT

Thank you saglamtimur ,

That is unfortunate.

Re: Power BI Report Builder and SSRS Report Manager

Anonymous — Wed, 05 Aug 2020 12:15:36 GMT

Thanks for your reply KBO ,

We have a Power BI Data Model that took quite a bit of effort to develop and has all of the data needed for writing reports.

My ultimate is to somehow be able to use that data model to build SSRS reports. It would be nice to be able to use the Power BI shared dataset as a SSRS shared dataset, or some how import the Power BI Data Model into SQL Server with all of the table relationships.

Re: Power BI Report Builder and SSRS Report Manager

d_gosbell — Thu, 06 Aug 2020 00:12:11 GMT

Using Analysis Services tabular is really the only option currently for sharing data sets on-prem. You *might* be able to connect to the Power BI file using Tabular Editor and then deploy that to a SSAS Tabular instance. I have not tried this, but it may be possible.

Re: Power BI Report Builder and SSRS Report Manager

Anonymous — Thu, 06 Aug 2020 02:12:37 GMT

Thanks d_gosbell ,

That sounds promising and echos some of the research that I've been doing. I will head down that path and post my results when I get them.