Some topics I think you should cover in videos: 1. How to use parameters to filter DAX queries, basically how the interface is setup to filter DAX queries using parameters 2. What you should import and what you should calculate in Report Builder 3. Properly naming sheets in Excel 4. Dynamic images in Report Builder
Hi, I used my Power BI data set as data source in the report builder. I had 2 tables linked by an ID in my PBI data set but this connection didnt flow to the report builder app. How can I fix this? Thanks!
Hi, If i use show/hide columns there is white space left to the right of my paginated report, how do i remove that white space, paginated report doesnot allow to set the width of tablix or report dynamically in runtime. How do I achieve it.
Patrick When I use show/hide columns the table is shrinking and there is white space left to the right of the report, how do i remove that white space.
Patrick I have huge data in my database, I want to load data into power bi dataset in partitions, and merge everything into single dataset and use in my paginated report. How can I achieve it. How to dynamically handle partitions when they increase
Hello guys! Thanks for the video! I already donwloades the Report Builder and I don't see the Card visualization available. It will be available in the future?
Hi. I am selecting a non-premium Datasource and it is working fine, but when I do the Copy Query from the Power BI visual to create the dataset it is not working - cannot create the fields and questions the connection to the datasource - but I am logged in. Any thoughts?
Is it possible to have multiple tabs in a paginated report similar to Excel workbook tabs? We have 6 reports that are related and would be great to implement them as 6 different tabs or sections of the one paginated report. Thanks!
Question... When you source your datasource from power bi Dax and need to build 2 different datasets from your powerBI Queries how do you create a relationship between the 2 different DAX datasets? I am wanting to create a parameter that looks at the "Account" in dataset 1 and filters the table in dataset 2 with a built relationship of account number to account number. It looks easy to do if you use a SQL data source but I haven't seen how you can do this with a powerbi data source.
Hello, do you know if we can change the default name of the file to exclude a parameter? Say the report name is "Sales Export" and you can select the location parameter. If I select "Colorado" as the location and hit export to excel, can it rename my file as "Sales Export Colorado"? My searches has showed me how to name tabs but not the whole file. Thank you in advance for any insight!
Having trouble displaying Document Maps in Paginated Reports when deployed to PowerBI Service, is that possible ? it works on desktop version - Thanks, Andres :)
Hi, I am new to paginated reports in power bi. My users want to hide /show columns to generate custom reports. This should also work when the report is exported to any format. Is it possible to design interactive report with report builder?
Great video! Love the tips for getting started. I'm just getting into paginated reports myself and am wondering if it's possible to make a report that would iterate through a list of customers. For example, if I wanted to have a paginated report that would show past due/aging details for individual customers. I would want a pixel perfect, single page layout/design and only have one customer on a page but have the report iterate through the list of customers. The customer list would be coming from the dataset and be dynamically filtered to only customers with past due accounts (or other criteria) to be able to generate a standard pdf that could be sent to customers on a monthly basis without having the manual effort of selecting 1 customer at a time and then printing 1 page when the customer list might be a couple hundred customers long.
Patrick I just downloaded the Power BI Report Builder .. but the # of data sources are still the same not much have been added should I a new link for downloading it for now I have the latest version 15.0.1425.0 of the Paginated Reports Builder
That is the latest version of Power BI Report Builder. www.microsoft.com/en-us/download/details.aspx?id=58158 The available data sources are still a little small. This should improve over time. Is there a specific data source you are working with?
I think it currently is true. But its mentioned in the video (3:27) that by the end of June 2019 we can get data from any Dataset. I'm eagerly waiting for that.
@@AnweshGangula They mentioned we can get data from any dataset in june 2019 but to host the actual rdl (paginated report) file I believe the workspace still needs to be a premium capacity. I didn't hear them actually say pro users can save paginated reports in a non premium workspace.
Good video, however, may I suggest if you could please cut down on your unnecessary talking? Like talking to the paginatedbear. and so many unnecessary comments. Otherwise, everything is very useful.
![📊 Power BI [What are Paginated Reports and Should You Use Them?]](http://i.ytimg.com/vi/Dm40UkHmtos/mqdefault.jpg)
![📊 Power BI [What are Paginated Reports and Should You Use Them?]](/img/tr.png)
Some topics I think you should cover in videos:
1. How to use parameters to filter DAX queries, basically how the interface is setup to filter DAX queries using parameters
2. What you should import and what you should calculate in Report Builder
3. Properly naming sheets in Excel
4. Dynamic images in Report Builder
Thanks for the video, One question, How can I fit multiple columns to show in one page
Do you have to be using the new workspace experience for the report builder to connect properly?
Hi, I used my Power BI data set as data source in the report builder. I had 2 tables linked by an ID in my PBI data set but this connection didnt flow to the report builder app. How can I fix this? Thanks!
when I copy query and then paste it, I get a dataset but the columns don't come with it.
Thanks for the video! Is there any limitation on paginated reports in connecting to the power bi dataset that uses the live connection to AAS?
Hi,
If i use show/hide columns there is white space left to the right of my paginated report, how do i remove that white space, paginated report doesnot allow to set the width of tablix or report dynamically in runtime. How do I achieve it.
Patrick When I use show/hide columns the table is shrinking and there is white space left to the right of the report, how do i remove that white space.
Patrick I have huge data in my database, I want to load data into power bi dataset in partitions, and merge everything into single dataset and use in my paginated report. How can I achieve it. How to dynamically handle partitions when they increase
Hello guys! Thanks for the video!
I already donwloades the Report Builder and I don't see the Card visualization available. It will be available in the future?
Hi. I am selecting a non-premium Datasource and it is working fine, but when I do the Copy Query from the Power BI visual to create the dataset it is not working - cannot create the fields and questions the connection to the datasource - but I am logged in. Any thoughts?
Is it possible to have multiple tabs in a paginated report similar to Excel workbook tabs? We have 6 reports that are related and would be great to implement them as 6 different tabs or sections of the one paginated report. Thanks!
Question... When you source your datasource from power bi Dax and need to build 2 different datasets from your powerBI Queries how do you create a relationship between the 2 different DAX datasets? I am wanting to create a parameter that looks at the "Account" in dataset 1 and filters the table in dataset 2 with a built relationship of account number to account number. It looks easy to do if you use a SQL data source but I haven't seen how you can do this with a powerbi data source.
Exciting news! It'a great oppertunity to use with a lot of solutions/customers!
Can you schedule Daily to excel to a location on sharepoint online?
Hello, do you know if we can change the default name of the file to exclude a parameter? Say the report name is "Sales Export" and you can select the location parameter. If I select "Colorado" as the location and hit export to excel, can it rename my file as "Sales Export Colorado"? My searches has showed me how to name tabs but not the whole file. Thank you in advance for any insight!
How do you add parameters in this way of creating a dataset?
Having trouble displaying Document Maps in Paginated Reports when deployed to PowerBI Service, is that possible ? it works on desktop version - Thanks, Andres :)
Is it possible to create a data source by using Excel data in Power BI report builder?
waiting impatiently for the end of june
Hello, cool tutorial. What software do you use for mouse highlight and clicks?
Hi, I am new to paginated reports in power bi. My users want to hide /show columns to generate custom reports. This should also work when the report is exported to any format. Is it possible to design interactive report with report builder?
Yes there are videos on how to show and hide columns conditionally
Great video! Love the tips for getting started. I'm just getting into paginated reports myself and am wondering if it's possible to make a report that would iterate through a list of customers. For example, if I wanted to have a paginated report that would show past due/aging details for individual customers. I would want a pixel perfect, single page layout/design and only have one customer on a page but have the report iterate through the list of customers. The customer list would be coming from the dataset and be dynamically filtered to only customers with past due accounts (or other criteria) to be able to generate a standard pdf that could be sent to customers on a monthly basis without having the manual effort of selecting 1 customer at a time and then printing 1 page when the customer list might be a couple hundred customers long.
Yes, you can absolutely do this with paginated reports! We'll cover this in a future video/blog post.
What some good templates for reporting tool
how can we show the selected filter in powerBI report can you help me out?
Do dataflows work in paginated reports?
Patrick I just downloaded the Power BI Report Builder .. but the # of data sources are still the same not much have been added should I a new link for downloading it for now I have the latest version 15.0.1425.0 of the Paginated Reports Builder
That is the latest version of Power BI Report Builder. www.microsoft.com/en-us/download/details.aspx?id=58158
The available data sources are still a little small. This should improve over time. Is there a specific data source you are working with?
Can you embed Paginated Reports in PBI pages/reports/dashboards? Or use it as a visual?
Not currently, but that is an idea we're considering in the future.
But SSRS report visuals CAN be pinned to Power BI dashboards since forever now I think... I hope this functionality comes out.
Awesome, you guys are rocking!!
This should be totally integrated into Power Bi.
A lot feel the same way. It is really a different experience though from Power BI Reports. I'm sure it will get better over time. 👊
Report builder is easy to use (basic design) but writing calculations in report builder is not at all.
6:00
Is it true that paginated reports only work at the Premium level? Or can Pro's create them and share with other Pro's?
I think it currently is true. But its mentioned in the video (3:27) that by the end of June 2019 we can get data from any Dataset.
I'm eagerly waiting for that.
@@AnweshGangula They mentioned we can get data from any dataset in june 2019 but to host the actual rdl (paginated report) file I believe the workspace still needs to be a premium capacity. I didn't hear them actually say pro users can save paginated reports in a non premium workspace.
@@dancastillo8370 well that's a bummer 😐
Wait wait wait, @cfinlan - ahem, I mean Pagi's assistant - is a Phillies fan?! How did I never know about all these Philly connections!
Of course - I lived in Philly for most of my life, graduated from Temple University, went to the Eagles Super Bowl, etc. :)
Whoa, I worked at Temple for 5 years and had no idea. Also did my master's there 🤯
Josh Caplan is also from Philly area. very small world 👊
To nessa onda uraaa #powerbinareal
Coolest Dudes on the planet!!
million thanks
Lol Does TIFF know JSON?
Is there a wizard to keep me from killing myself trying to figure out this software?
hi
solo vergas que sabe ingles jaja, no le van a entender a este comentario jajja
Good video, however, may I suggest if you could please cut down on your unnecessary talking? Like talking to the paginatedbear. and so many unnecessary comments. Otherwise, everything is very useful.