Power BI Paginated Reports: Data source, Dataset and parameters

Paginated reports in Power BI are now available. Patrick walks you through how to get started with a paginated report using Report Builder. In this video, he starts off with how to create an embedded data source, a dataset, and parameters.

LET'S CONNECT!

Guy in a Cube
-- Snapchat - guyinacube

***Gear***

#powerbi #paginatedreports #guyinacube

[LuhAlberto]

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

[the_empress_dej]

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

[clementngoga]

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.

[andrecavasotero]

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

[georgehouston]

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

[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!

[vinaljain]

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

[peterlapic]

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.

[christiannoackaguila]

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

[sushiljagtap]

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 ?

[malikmuhammadawais]

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.

[denwo]

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 ...

[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!

[rishabhramchandani]

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

[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.

[leeperry]

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

[mustafabiviji]

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).

[thesoothingbutterfly]

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.

[marcelrene]

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.

[pthapa]

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.