Power BI Report Server

What do you do when you want to use the Visualizations of Power BI but management doesn’t want to send company data to the cloud? Well, you can implement Power BI Report Server! In this episode we discuss the differences in architecture with the on-premises version of Power BI along with the limitations and options this version brings.

Episode Quotes

“In my mind, Power BI Report Server is a superset of SQL Server Reporting Services. I’m fairly certain that a lot of the bits underneath are exactly the same.”

“That’s the price you pay of wanting a cloud service on-prem, so you’re always going to be a few months behind. I mean, they generally sync up every quarter, but you’re going to be lagging behind.”

“You can use Report Server to publish through the Power BI service, but you cannot do it the other way around.”

Listen to Learn

00:38     Intro to the team & topic
01:21     Compañero Shout-Out
01:37     SQL Trail Update
02:12     Do you want a podcast t-shirt?
02:50     SQL Server in the News
04:51     More details on the Power BI Performance Analyzer
08:16     Report Server is the on-premises offering for Power BI
11:02     Eugene lost power, but he made it back to the conversation!
11:50     Reporting Services and Power BI Report Server on the same server?
14:15     Power BI is the next version of Reporting Services
18:00     Report Server can publish through the Power BI service, but not the other way around
20:17     And then it will feel a lot like Reporting Services
22:10     Kevin’s experience with Power BI Report Server
23:22     Has anyone leveraged automated sending of reports? Cultural battle?
25:43     Other limitations Power BI Report Server
26:38     How data gets updated in Power BI Report Server
27:57     There is a hybrid option – using both the cloud and on-premises options
29:22     Closing Thoughts


Music for SQL Server in the News by Mansardian

Meet the Hosts

carlos chacon headshot

Carlos Chacon

With more than 10 years of working with SQL Server, Carlos helps businesses ensure their SQL Server environments meet their users’ expectations. He can provide insights on performance, migrations, and disaster recovery. He is also active in the SQL Server community and regularly speaks at user group meetings and conferences. He helps support the free database monitoring tool found at databasehealth.com and provides training through SQL Trail events.

eugene meidinger headshot

Eugene Meidinger

Eugene works as an independent BI consultant and Pluralsight author, specializing in Power BI and the Azure Data Platform. He has been working with data for over 8 years and speaks regularly at user groups and conferences. He also helps run the GroupBy online conference.

kevin feasel headshot

Kevin Feasel

Kevin is a Microsoft Data Platform MVP and proprietor of Catallaxy Services, LLC, where he specializes in T-SQL development, machine learning, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL, president of the Triangle Area SQL Server Users Group, and author of the books PolyBase Revealed (Apress, 2020) and Finding Ghosts in Your Data: Anomaly Detection Techniques with Examples in Python (Apress, 2022). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather's nice enough.

Want to Submit Some Feedback?

Did we miss something or not quite get it right? Want to be a guest or suggest a guest/topic for the podcast?

Let's find what you're looking for