Power BI Paginated Reports GOTCHAS! - Part 1 - The Query Designer

[@mikelaw4036]

Thank you sir for putting this video together. This is indeed very helpful. I am new to DAX and this solves my issue. One thing that I was trying this morning was to add a filter in the DAX query. I got it to work now. Thanks again

[@Acheiropoietos]

Man, this has been a life-saver. Utterly indispensable for using PBI datasets with paginated reports.

[@sharmitasahaporshia333]

Honestly the most useful and "on-point" video on Power BI report builder...thanks.

[@GreyskullAnalytics]

Thanks. I'm glad it was useful 😊

[@adnanebekkaoui9480]

Just finished the Part 1, you are a lifesaver, big big thumbs up!!! Thank you!

[@cmtoufique2194]

Just subscribed to your channel. I was struggling to find contents related to this topic on YT. Thanks for sharing

[@VidcomNZLTD]

Really Good reminder Video if you've done it before and forgotten what is needed to get that parameter in place. That wee 'Hidden' Flag on the query Designer got me... Thanks you've helped me no end with that.

[@emilymurphy6936]

Thank you so much for this. The parameters were driving me crazy!

[@andresvargasperez5395]

Best video I've ever watched on Paginated Reports!

[@juansepowerplatform]

Thanks for this, could you do a video on how to setup parameters so they can be used with the Powerbi export to file for paginated reports connector and how to pass them in powerautomate?

[@mr.civility389]

Thank you so much, the fact that the parameter checkbox is not displayed by default based on the resolution is kinda crazy, I only figured it out thanks to you

[@powerb_i]

Very helpful video - thanks!

[@sue_bayes]

Rewatched this again today, brilliant thank you Johnny

[@mchopra1989]

This is one of best explanation on Power BI paginated report. Thanks alot.

[@emilymalkin270]

We need more content on using power bi datasets with paginated reports - thank you!

[@bichannel3419]

Answered many of my questions. Thank you!

[@roy0dissident]

THANK YOU!! i couldn't find the Parameter option and all i had to do was make the window bigger. d'ouh!

[@alexsin4821]

Where have you been before with your videos?
Great job. Thanks 👍

[@douglasjackson8488]

So good man. The Visual DAX copy method is alot more confusing

[@theg9811]

Great Video again Johnny..keep up the good work!

[@andrewtran772]

Great video! Any tips for connecting to published datasets on the PBI service that are connecting to the data source via Direct Query? Oddly Report Builder doesn't render any data (vs connecting to a published dataset connecting via Import). Thanks!

[@GreyskullAnalytics]

I've never experienced that before. It should be supported. one possible course of action is rather than connect to the dataset, use the analysis services connector and connect to the XMLA endpoint instead. I guess you could also query the source data directly too

[@seederism]

Bro hope you doing good. This was a great help to me thank you very much

[@kaustubhchaukekar5436]

Hi , how can I select date

[@amandadickson2329]

Can you set a date parameter that is descending and removes future dates?

[@yon_draper]

I'm getting this error when creating a parameter based on a date range
"The property 'ValidValues' of report parameter 'FromLoadDataActivityDate' doesn't have the expected type."
does anyone know how to fix this ?

[@bobbyw1074]

Hi Johnny, I have a power bi table that uses a measure, and I am filtering for today's date inside the measure (not with a slicer). But when I drag this measure in query designer, it doesn't filter. How can I get it to still filter?

[@pavl0sh456]

Hey Greyskull, are there any perfomance differences between Power BI dataset and dataset based on direct Azure SQL and what's better to use?

[@johnnywinter861]

It depends on many different factors I'm afraid.