Power BI Paginated Reports GOTCHAS! - Part 6 - Date Parameters

Part six of the Paginated Reports 'GOTCHAS' series where Johnny shows some of the odd behaviour you might encounter when you use date parameters in your report

Chapters:
0:00 Intro
0:40 Strange data parameters
1:51 Examining the DAX
5:55 Create date picker parameters
8:34 Map parameters to query
9:55 Alternative approach using custom DAX

#PowerBI #PBI #BusinessIntelligence #PaginatedReports #ReportBuilder

Credits:
title music: written and recorded by ME!!!

[rebekahhenken]

THANK YOU! I was about to lose my mind -- your WTF?! moment was exactly my reaction.

[katehu]

I really loved this tutorial – it was a lifesaver! It helped me tackle a challenging problem at work that I’d been struggling with for quite some time. Your style of presenting the material is exceptional; it’s clear, engaging, and incredibly easy to follow. A big thank you for making such helpful content!

[DaveTube]

only partway through the videos but need to say a BIG THANKS to you Johnny. Clear and concise. You get the pain we feel and do not torture us with needless comment. Thank you again

[antonycatella]

You really do know how to explain things very simply. Thanks Johnny

[ferris]

Fantastic Work Johnny! Many hours spent trying to figure out how to use Date Parameters with a Power BI Dataset as the Data Source. Many thanks!

[madalinasima]

Thank you so much! This was an absolute lifesaver! I was on the verge of losing my mind trying to get the date range parameters to work!

[alexsin]

There is a separate place in hell for those who developed PowerBi report builder.
It was really good explanation. After hours of searching in Internet, finally i found someone who explained why it doesn't work.

Great job.

[daleksnemesis]

Thank you so much!! I couldn't find an answer for this anywhere until I watched your video. I'd been struggling with a project for weeks. My hero!!

[pennyrobards]

Love you! This date thang...giving me PTSD!!! you are a nerve

[ChrisView]

I had the same look on my face when I saw the generated DAX when I added date parameters. That look is priceless! Great videos!

[charliemather]

Johnny, great video! Power BI Report Builder can certainly stand even more enhancements. Glad we can finally paste the DAX code in the initial dataset window. Nice job pointing out not only the gotchas, but workable solutions!

[albertmartinez]

Wow, great video explaining the funky date parameters and the automated dax queries report builder generates. You have gained a new subscriber! Cheers!

[scottleckie]

Thanks a lot for this one. A great video & so helpful. Also, comedy gold from 3:10 to 3:17 😆

[SeattleDataGuy]

Great walk through for paginated report gotchas. I look forward to more videos!

[sjnyce]

Ahh thank you, this really sorted out my headache, I now have a new problem of how to limit the rows my report fetches.

[carolpruett]

OK, I'm additionally impressed that you wrote and recorded your own music to this video. The content of the lesson is going to help me so much at work. I was struggling with date parameters yesterday and you addressed each of the odd problems I experienced with them.

[navinaveena]

Thanks for the video. It really helped me. I am new to paginated report it took me few hours to break this after watching your video solved the issue in few minutes. Once again thank you for the video :)

[juansepowerplatform]

Thanks for showing this, I never knew how this worked and got around by passing separate parameters for year and month, so users will select from 4 parameters in a range scenario. I like that know I can use a date picker.

[hip]

Can’t believe this video solved my issue perfectly - thank you!!!

[DJALEXRRR]

Thank you so much! I was really banging my head against the desk with these data parameters 😅