Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

URL parameters

one of the parameter passing is not passed into the paginated report paramater. it is a date parameter for some of the dates it getting correctly passed and for others it is showing like this

 

sambhu_2-1611804020589.png

2 ACCEPTED SOLUTIONS
parry2k
Super User
Super User

@Anonymous I recently did a session in Vancouver meetup on paginated reports and one of the sections was to pass parameters from Power BI to call paginated report which contains date. Can you make sure you are using the correct parameter name when creating a URL, here is my measure that I used in Power BI desktop to call the paginated report and passing parameter values. 

 

 

Export URL = 
VAR __baseReportURL = "https://app.powerbi.com/groups/xx-xx-xx/rdlreports/yyy-yyy-yyy"

VAR __parametersCustomer = "rp:DimCustomerCustomer=" 
VAR __parameterCustomerValue = 
        __parametersCustomer & 
        CONCATENATEX ( 
            VALUES ( 'DimCustomer'[Customer] ), 
            'DimCustomer'[Customer],
            "&" & __parametersCustomer
        ) 
VAR __parameterFromDate = "&rp:FromCalendarDate=" & FORMAT ( MIN ( 'Calendar'[Date] ), "YYYY-MM-DD" )
VAR __parameterToDate = "&rp:ToCalendarDate=" & FORMAT ( MAX ( 'Calendar'[Date] ), "YYYY-MM-DD" )
VAR __exportSettings = "&rdl:format=EXCELOPENXML&rdl:reportView=pageView&rdl:parameterPanel=hidden&rdl:targetSameWindow=true"
RETURN
__baseReportURL & "?" & __parameterCustomerValue & __parameterFromDate & __parameterToDate &  __exportSettings

 

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

HI @Anonymous,

You need to know the embedded paginated report URL first, then you can copy it and use it with Dax expression to concatenate the URL with filters.
After these, you can set the button action type to 'web URL' and bind it to your measure formula. (notice: change the data category of measure to web URL)

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

5 REPLIES 5
parry2k
Super User
Super User

@Anonymous well if embedded URL can be directly called I don't see why it cannot be done using action. It is all about constructing the URL.

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

@Anonymous I recently did a session in Vancouver meetup on paginated reports and one of the sections was to pass parameters from Power BI to call paginated report which contains date. Can you make sure you are using the correct parameter name when creating a URL, here is my measure that I used in Power BI desktop to call the paginated report and passing parameter values. 

 

 

Export URL = 
VAR __baseReportURL = "https://app.powerbi.com/groups/xx-xx-xx/rdlreports/yyy-yyy-yyy"

VAR __parametersCustomer = "rp:DimCustomerCustomer=" 
VAR __parameterCustomerValue = 
        __parametersCustomer & 
        CONCATENATEX ( 
            VALUES ( 'DimCustomer'[Customer] ), 
            'DimCustomer'[Customer],
            "&" & __parametersCustomer
        ) 
VAR __parameterFromDate = "&rp:FromCalendarDate=" & FORMAT ( MIN ( 'Calendar'[Date] ), "YYYY-MM-DD" )
VAR __parameterToDate = "&rp:ToCalendarDate=" & FORMAT ( MAX ( 'Calendar'[Date] ), "YYYY-MM-DD" )
VAR __exportSettings = "&rdl:format=EXCELOPENXML&rdl:reportView=pageView&rdl:parameterPanel=hidden&rdl:targetSameWindow=true"
RETURN
__baseReportURL & "?" & __parameterCustomerValue & __parameterFromDate & __parameterToDate &  __exportSettings

 

 

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous
Not applicable

Thanks @parry2k  

One  more quick question  in this we pointing to the power bi serivice URL on button action . when we embedding the reports  is it a way to link to the paginated report embedded using the button action .

the main report in Desktop and linking to the paginated report.

HI @Anonymous,

You need to know the embedded paginated report URL first, then you can copy it and use it with Dax expression to concatenate the URL with filters.
After these, you can set the button action type to 'web URL' and bind it to your measure formula. (notice: change the data category of measure to web URL)

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
lbendlin
Super User
Super User

Are you providing the date in ISO8601 format?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors