Power BI Paginated Reports: Data source, Dataset and parameters

[@LuhAlberto]

Thanks Patrick for the Dummies like me. Hugs from Brazil :)

[@GuyInACube]

Most welcome! thanks for watching! 👊

[@denwo1982]

You can’t have a shared data source? What if you are switching environments from Dev, Test, Prod and you have over a 100 reports? You have to manually change every reports data source!? This can be dangerous ...

[@clementngoga3751]

Hello Patrick, Are any complete courses paid or free on Power BI from scratch to advanced from your end? I check videos based on what I want to do but I always have some loophole and would like to capture the complete Power BI operations.

[@andrecavasotero6234]

Excellent video. But the best is yet to come in the next videos.

[@GuyInACube]

Lots of good stuff coming. Thanks for watching Andre!

[@the_empress_dej]

Thank you!! I tried to read the Microsoft instructions on this but it made no sense. You laid it out perfectly.

[@Prateeksha1993]

How can we set parameters for a paginated report that uses shared datasets?

[@georgehouston7256]

Fantastic stuff, thank you. Please do a walk-through of a connection string for a SharePoint Online List?

[@malikmuhammadawais1425]

Hi Patrick, I have a parameter and in the query, that parameter will have duplicate values in that column. When I run the report it shows the duplicate values in the drop-down list. Will be great if someone can guide me to resolve this. Thanks and regards.

[@rishabhramchandani2322]

Can we create parameters that auto select things? Such as present date? or Present date -7?

[@MehdiRazaToronto]

Great quick video

[@pthapa55]

Hello Patrick, When I right click on report builder to add the Data Sources, I can't see the option to add Power BI dataset connection. Is that something I have to enable some where, can you please help. Appreciate in advance.

[@DennisCaunce]

can you pass a parameter to the query, when using powerBI as a datasource?

[@pankajkishore2257]

Can we connect power bi dataset which has been created using import mode.

[@vinodreddyyeruva5241]

Hi., I am using power bi measures in paginated report. I am getting wrong values in totals field In paginated report. I am using table view and for each column I am calculating totals at the top.

[@husseinabbas2104]

Hello patric Please make a video on how to pass multiple parameters to stored procedure in sql server database

[@leeperry7969]

Hi Patrick, I downloaded RDL files from your link, but can't open them with report builder and got error msg "Failed to open report - DTD is prohibited in this XML document." Is there a way to fix it? Thanks

[@kuppireddydamodhar4493]

Can we call data to power bi using oracle database by writing stored procedure in advanced SQL statement

[@devindersingh1951]

Hi Patrick how to achieve MAT, MAT LY, YTD and YTD LY in Report Builder ..pls suggest

[@anhnguyenduy6861]

I have no idea why my pbi report builder is not connecting to the ms sql server on prem that I set up locally using .\ as advised. anyone have any idea how to debug this? thanks. I added ms sql server onto firewall and also enabled TCP/IP, but nothing helped.

[@nagoorpashashaik8400]

Any idea how to connect Power BI Paginated Reports with ODBC Support?

[@marcelrene8813]

Is there a way we can create paginated report, attaching the fields on text box instead of a table. If so, can you send me an example. Most of the videos use tables. What i need is a paginated report with separeted fields? Can we do that on PBI Reports? Like a form.

[@peterlapic6761]

Are there any benefits using this instead of Visual Studio? I only see disadvantages as you don't have source control and no support of shared datasets.

[@NishatYasmin]

Hi, Patrick! In your Connection Type dropdown (2:30), I see you have quite a few more options than I'm seeing for myself! How did you add ODBC? Right now, I only have Microsoft SQL Server, Microsoft Azure SQL Database, Microsoft SQL Server Analysis Services, Oracle Database, Enter Data, and TERADATA. I'm able to connect via ODBC in PowerBI but not PowerBI Report Builder. Any help would be appreciated!

[@Dfoliveira25]

@guy in a Cube, I am having the same problem. Any idea?

[@bryanchaves5691]

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!

[@vinaljain]

HEY !! Thank you for the informative video By the way is it possible to apply page break on a Column chart .?

[@ruchikasoni3192]

Can you also show us How to create a date parameter (as a calendar) from the dataset in the Power BI report builder? for some reason, it would not recognize it as a date field. Or in other words, If I have a measure which is filtering upon date slicer, How will this work in Report builder?

[@triparnaray]

Hi Patrick,thanks for that. any pointer to get datepicker for from date and to date in paginated report.

[@David-yq6un]

Hi! It could be possible to add the link of the video about Azure Sql that you have talked at the beginning of the video? Thanks!

[@DJCousinRandy]

When you show that you can create reports in Visual Studio, you have the preview button available to test the report. I am trying to create a report in VS2017 Pro am I do not have the preview tab/button available. Do you know how to enable this or can you point me in the right direction? Thank you. Nice video series BTW.

[@GuyInACube]

The preview button is only in Report Builder. Visual Studio, you need to just run the report. You should be able to right click on the RDL file and run that report from Visual Studio.

[@sushiljagtap2174]

Hi Patric , i am using odbc data source for connecting to snowflake database. I believe it works on direct query mode as each time query is fired against database . Am I correct ? I don't have link which supports that. Do you know anything about that ?

[@adeabraham126]

paginated report: can I change the data source for a similar data source to keep the same report?

[@CSteinberg03]

I am having trouble adding a PowerBI Dataset as a Data Source. Seems straight forward, but I seem to not be able to authenticate to the report when I try to add the dataset even though it shows. Any insight or perhaps a video update?

[@billfarmwald8034]

Can Power BI Data Flows be used to create paginated reports in Power BI Report Builder?

[@christiannoackaguila9362]

Hi! Which reproduction list would you recommend to get first steps into Power BI?

[@Ibraheembinmehmood]

Hi, I want to use Excel as my data source. Can we connect Report Builder to Excel?

Hey Patrick, A year has passed, any plan to release the use of a shared datasource. Deployment of several reports is a nightmare without this feature.

[@djpirra]

Shared connections is already supported today?

[@guguli19]

How to execute a PBI paginated report when any one data source is not accessible

[@pauldongallo2359]

How about the Data source from excel? is not possible on Power BI Report Builder?

[@gopichand5717]

Can we connect to our dataset to create paginated reports

[@livings4086]

is anyone using or know if you can PowerBI datasets in report builder?

[@mustafabiviji00711]

Hi Patrick, Appreciate you creating videos on paginated reports. Are there any resources you can advise where one can go and see good examples of paginated reports. While Power Bi gave the modern look and feel, we are struggling to find good examples of paginated reports - would you be share resources where we can experience a good variety of modern looking paginated reports? (just like Power BI has data stories gallery).

[@GuyInACube]

There isn't a gallery like there is for Power BI. I'm not aware of any resource for that. :( maybe someone else can comment on something?

[@thesoothingbutterfly9614]

Heyy patrick first i wanna say i love your videos n they are a gr8 help since im a new power bi learner But i wanted to ask u how can i dynamically extract a column with distinct values from an existing column of a tablein power bi , i hve been unable to do it so i really need your help.

[@amrutaallundi9851]

Can you please help with scheduling gateway refresh of paginated reports ?

[@GuyInACube]

You don't schedule a refresh on a Paginated report. You schedule refresh on a dataset or dataflow.

[@victorhuang5485]

Could this report publish to Power BI Report Server On-Premise?

[@michalgebala3242]

hello does those type of reports supports data gateway integration?

[@mnelson10000]

So this will not be available in Power BI Desktop...? Seems like another Access or SSRS retread

[@RichardParsons65]

Yeah - just SSRS tagged onto Power BI. Good for the Power BI Service to show list reports, as well as just visualisations.

[@sqwale7]

This requires my laptop to be on. I'm running a postgres server on google and i just want it to refresh how do i do that? It's actually kind of ridiculous that is't not easy to do. When i create the reports on Power bi desktop i use odbc,once i publish it so i can share. It becomes messy. It needs my laptop to be on. Why isn't it straight forward to just enter credentials and it connects.

[@hiteshsingh1519]

can please share credentials of the file which you have shared on github

[@marklund7498]

Hi Patrick, Is there any way to pick up the Username() of the logged in user, so we can pass that to our Stored Procedure and implement some sort of RLS?

[@BigTerrick]

You probably found it by now, but try out the Built-in Field "User ID". Be aware it returns different results when running On-prem vs. the Power BI Service. On-prem returns DOMAIN\UserName, and when running in the Power BI Service it comes across as the User Principal Name and will look more like [e-mail]. I ended up building a SWITCH expression that used InStr to look for the \ or the @.

[@Karenshow]

Can you show how to do set the store procedures?

[@GuyInACube]

Was the walkthrough at [04:35] not enough?

[@russsauers]

I have tried to upload my RDL files only to get errors, which say to call support. I have tried simple to complex, always the same error.i know this is in preview but I was hoping to try it with some existing reports. All were created with report building and have SQL Server as data source. Looking forward to next video! Love the videos, thanks for all your help here and at your monthly live sessions!

[@cfinlan]

Hi Russ, do you have the paginated reports capability turned on for the workspace you’re looking to upload to? Do you have subreports or any clickthru actions in your reports? Please let me know!

[@GuyInACube]

Thanks for watching Russ! Sorry to hear you are hitting some problems. Be sure to get back to Chris's comments. He is the man on this feature :)

[@russsauers]

I will check to make sure it’s turned on with our admin. I have tried with basic reports, no click through all the way to reports with click through. I assumed we had it turned on but that may be it. Thanks!

[@russsauers]

Chris, I found our issue, we are splitting the cores dedicated to capacity for certain workspaces, the option isn't available for us. Thanks.

[@brentlightsey783]

Patrick - Thanks for putting this up. I thought the magic was that SSRS reports would be able to connect to our Power BI Datasets. With them supporting XMLA endpoints, shouldn't it be possible? I'd like to use the Power BI Dataset as my one version of the truth and give my users the flexibility to present those reports either as interactive dashboards (Power BI) or paginated reports (SSRS). Is that the direction this is heading, or will SSRS and Power BI reports pull from different places in the Power BI Service?

[@GuyInACube]

It isn't yet. It will be coming. Check out the following doc for the current limitations - docs.microsoft.com/power-bi/paginated-reports-report-builder-power-bi. It just came out in public preview. There is still work to do.

[@rudnickj]

I was trying to follow along locally, but don't have a login or password for the demo data :(

[@GuyInACube]

You would need to have the AdventureWorks database in some database server. Then use the credentials for the server you put it on.

[@paorodma]

Hi Patrick, love your videos. I still have a big question I have not been able to answer. Can I execute the paginated report trough an API, sending the parameters and getting back a PDF? Thanks in advance!

[@GuyInACube]

Not today. URL Parameter usage is coming soon though. We will definitely have a video on doing this once it is available.

[@paorodma]

@@GuyInACube thanks for your prompt response. Let's hope we see this soon. 👍

[@tabithab79]

Q: can you show me how to publish.rdl files to power BI

[@1spunch]

Cool

[@corydwagner]

Will this be available in Pro or ONLY Premium Capacity? I need this functionality, but I won't be able to use it if it's Premium only.

[@GuyInACube]

It is a Premium only feature from the Power BI service perspective. Some of this is due to technical limitations of how SSRS was architected. You can still use paginated reports in SSRS or Power BI Report Server.

[@pukashell6170]

So can you connect to a Power BI Data Model? It did not seem to be an option. Will that be available at some point. Ideally, I'd like to be able to link the paginated report to a PBI report where all the slicer options can be ported to the paginated report and it prints out using the pre-filtered Power BI data set.

[@GuyInACube]

Not yet. It is coming though. Check out the following doc for a list of current limitations - docs.microsoft.com/power-bi/paginated-reports-report-builder-power-bi

[@buuutruong9494]

Patrick, nice meeting you at MBAS last week. I believe you did a demo on connecting PBI Report Builder desktop to PBI Service - a existing dataset on premium workspace. Do you have that sample by any chance? thanks. BTW - Enjoy your session especially giving Adam hard time :-)

[@mshparber]

I still don’t get it... How is it different from the simple old SSRS?

[@mustafabiviji00711]

I think this is the same as the old SSRS paginated reports, just that now its all in one platform, and eventually the Power BI & Paginated reports will be better linked, I guess. I was hoping Power BI features would take over or handle all features of paginated reports.

[@Karenshow]

Do you build any data model with the data sets?

[@GuyInACube]

As of right now, Paginated reports don't support using Power BI datasets as a data source. It has been stated that will be coming as it gets closer to GA, or maybe shortly after. It is still Preview currently.

[@ricardoabella867]

Why Microsoft doesn't use the same easy process to create reports as in Microsoft Access Reports instead this so complicated process to create Paginated Report, Access and Power Bi are based on SQL Code

[@iseron]

this guy started a company since microsoft employe?

[@Karenshow]

Are data sets tables?

[@GuyInACube]

You can think of a dataset within a paginated report as a table. It is the defined query against your data source.

[@malcorub]

Bruh, this is just SSRS report development.