Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
ShaWo
Advocate I
Advocate I

On premise Power BI report server and desktop programs

We are thinking of having an on-prem power bi report server and also using the cloud service in the future. Do we need to think of the future architecture with having two seperate desktop programs for on-prem usage and for cloud usage? Or are they at some point in the future combining the two feature sets together in to one desktop program for designing the reports?

10 REPLIES 10
Anonymous
Not applicable

we need a tool a bit like SSRS where we design a dashboard and either publish to the cloud or an onprem server

Phil_Seamark
Microsoft Employee
Microsoft Employee

Hi @ShaWo

 

I'm pretty sure you use the same Power BI Desktop application to author reports for both onpremise and web-service reports.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Edit: Forgot to say Thank you @Phil_Seamark 🙂

 

Okay, that sounds good. It just gets pretty confusing when half of the documentation speaks of "Power bi desktop" and half of "Power BI desktop optimized for power bi report server"

 

Examples of both 

https://powerbi.microsoft.com/en-us/documentation/reportserver-quickstart-powerbi-report/

https://blogs.msdn.microsoft.com/sqlrsteamblog/2017/05/17/a-closer-look-at-power-bi-report-server/

@ShaWo there is a specific power bi desktop for SSRS

 

https://powerbi.microsoft.com/en-us/documentation/reportserver-install-powerbi-desktop/





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Thank you @vanessafvg, I'm aware of this and this is the source of all the confusion for me, since different sources within microsoft refer to different programs. For example the two documents I linked in my previous message

@ShaWo

 

i think it has to do with the configuration of publishing, its a different config to publish to ssrs vs to the service.  so i am sure you could develop in both however when you want to publish that might be where you have an issue





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




 @vanessafvg Yup, that was what I was afraid of. Thinking in advance, having two different programs for different publishing venues makes it difficult to understand for the regular user. And not even talking about the file association with pbix files and different desktop programs.

@ShaWo are you using both the service and SSRS?  





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvg not yet, but since the new premium model and the local on-premises server make it possible we have to think about the possibilities. It is tempting to have on premise server for some data and cloud for others but having two desktop programs (if that is the case?) makes it quite a hassle.

 

And to be clear I don't know if @Phil's comment of having only one program will be the future or not. There are comments from Microsoft in different documents about desktop and desktop for ssrs. Getting a clear roadmap for example about the development of desktop to one single program would be great. I realize that the logical way would be combining the two into one desktop program down the road, but who knows what they are thinking at Microsoft 🙂

@ShaWo  i think a lot of what microsoft are driven to do will depend on the Power BI community, so i agree it makes sense to combine the 2





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors