Episode 181
| November 13, 2019
| 21 minutes
Paginated Reports in Power BI
In the second quarter of 2019, it was announced that Power BI would support paginated reports–at first this was assumed to be connected to an announcement that Power BI would support the RDL files from Reporting Services. The guidance however, was to continue building paginated reports in Power BI. In the fourth quarter of 2019, more information emerged about paginated reports and in this episode we drill into the offering of paginated reports in Power BI and…shhh…we won’t spoil it, but an old friend just might play a role in this ‘new’ offering.
Listen to Learn
00:38 Intro to the team
02:19 What is going to happen with Reporting Services?
05:55 Are you developing reports in SSRS and then uploading them to Power BI?
07:55 Use cases when SSRS is a no-brainer
09:50 Using Report Builder is not the same as Power BI
12:18 Kevin’s experiences with Reporting Services and Power BI
14:28 You might start smelling like hobo urine
16:02 You wouldn’t use Report Builder without a SQL Server license…but you could
18:10 SSRS or Power BI…where you should be investing your time
19:41 Closing Thoughts
I feel like at some point, marketing went to the Power BI team and went, “alright, apparently, we still need SQL Server Reporting Services, but we’re not allowed to say the word Reporting Services ever again.
Meet the Hosts
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
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
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?