cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Power BI & Reporting Services - current state?

Hi,

i'd like to know, generally speaking, the current state of the art about how Power BI & Reporting Services relate.

 

More specifically:
1) PBIX files can already be shared internally through PBI Server in an organization? Or is it supposed to use SSRS 2016 for anything?
1.1) The experience through PBI Server is different from the PBI service, for example, no Q&A and no dashboards?

1.2) Does Microsoft intend to give, through PBI Server, a similar experience like the one online through PBI Service (with Q&A, dashboards, etc..)? 


2) Is PowerBI Service supposed to allow publication of SSRS reports?

 

3) What the h*ll happened to Datazen? Is it integrated in SSRS 2016, and will it live, since PBI and SSRS seem to become more and more integrated? 

 

Finally, what should be the Microsoft plan for these 2 software in the future? Will they end up like only one software - BI Reporting Services - an hybrid solution both working in the cloud and on premisses?

 

Kind Regards

4 REPLIES 4
Moderator v-qiuyu-msft
Moderator

Re: Power BI & Reporting Services - current state?

Hi @Anonymous,

 

1) PBIX files can already be shared internally through PBI Server in an organization? Or is it supposed to use SSRS 2016 for anything?

 

We can grant permission for users to access reports in web portal: Grant user access to a report server. You can also vote the idea about create a subscription for report: PBIRS subscriptions.


1.1) The experience through PBI Server is different from the PBI service, for example, no Q&A and no dashboards?

 

Power BI report server on-premise doesn't support Q&A and dashboards feature currently.

 

1.2) Does Microsoft intend to give, through PBI Server, a similar experience like the one online through PBI Service (with Q&A, dashboards, etc..)? 

 

You can vote on this idea: Support dashboards in Power BI Report Server.


2) Is PowerBI Service supposed to allow publication of SSRS reports?

 

We are not able to publish SSRS reports to Power BI service, while we can publish the pbix in Power BI report server to Power BI service.

 

3) What the h*ll happened to Datazen? Is it integrated in SSRS 2016, and will it live, since PBI and SSRS seem to become more and more integrated? 

 

Regarding Datazen, you can check this article: Announcing End of Support for Datazen Products.

 

4) Finally, what should be the Microsoft plan for these 2 software in the future? Will they end up like only one software - BI Reporting Services - an hybrid solution both working in the cloud and on premisses?

 

Regarding this question, maybe @mgmeyer and @riccardomuti come from PG team have information?

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User III
Super User III

Re: Power BI & Reporting Services - current state?

@v-qiuyu-msft 

Are you aware of a way to enable subscriptions on a Desktop file? The link you have does not specify Desktop files, and in my experiance the subscriptions option is disabled for the Power BI Files on Power BI Report Server...

 

 

I just have a point of clarification here as well. While you cannot publish a report, you can pin certain visual element from the RDL reports to the Power BI Service if you have a Premium license. In this manner, you can connect your on premises reports to the Service.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
Moderator v-qiuyu-msft
Moderator

Re: Power BI & Reporting Services - current state?

Hi @Seth_C_Bauer,

 

Thanks for your reminding. I have modified the first point in my previous post. The subscriptions for Power BI report server is under review, please vote it up. Smiley Happy

 

@Anonymous In addition to @Seth_C_Bauer's pin SSRS items to Power BI. You can go through this article: Pin Reporting Services items to Power BI Dashboards.

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power BI Team riccardomuti
Power BI Team

Re: Power BI & Reporting Services - current state?

Good points above. To the question about how Power BI Report Server and SQL Server Reporting Services (SSRS) relate and the roadmap for them, check out "A closer look at Power BI Report Server" as well. In short, Power BI Report Server is a superset of SSRS; it contains everything in SSRS, plus self-service BI via Power BI reports (*.pbix).

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors