Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous2809
Frequent Visitor

Filter the report by dynamic date filter even though if there is no relation

‎08-22-2023 09:55 PM

Hi All,

I met with one of urgent requirement that: I had a stored procedure in which someone had given startdate and enddate as parameters with limit that startdate is first day of current month and enddate is today but the requirement is in report I need a slicer where the date should be not bound to the stored proc used for report I need a seperate slicer where it is going to take last 2 years dates but while filtering the slicer it should filter the report that is used by stored proc also. Please kindly help me on this.

Message 1 of 9
470 Views
0
8 REPLIES 8
parry2k
Super User
Super User

‎08-23-2023 09:45 PM

@Anonymous2809 only works with DQ, not with import



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.

Message 8 of 9
404 Views
0
Anonymous2809
Frequent Visitor
In response to parry2k

‎08-23-2023 09:49 PM

Can you help me how to call the stored proc as directquery to report. It is not possible right @parry2k. Are there any alternative ways? Please help me

Message 9 of 9
400 Views
0
parry2k
Super User
Super User

‎08-23-2023 08:32 PM

That's exactly what my reply is and also mentioned in the docs. Seems like you completely missed that.



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.

Message 7 of 9
412 Views
0
parry2k
Super User
Super User

‎08-23-2023 10:09 AM

@Anonymous2809 are you using DQ?



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.

Message 5 of 9
426 Views
0
Anonymous2809
Frequent Visitor
In response to parry2k

‎08-23-2023 08:16 PM

No @parry2k  with Import i didn't find bind to parameter option after creating data table. In one of the posts I find that we need to provide it as Direct Query to find the option bind to parameter.

Message 6 of 9
417 Views
0
Anonymous2809
Frequent Visitor

‎08-23-2023 09:07 AM

Thank you for solution @parry2k . But i am unable to find bind parameter option

Message 4 of 9
429 Views
0
parry2k
Super User
Super User

‎08-23-2023 07:23 AM

@Anonymous2809 there are two way to solve it, don't filter the data in the stored procedure, get everything or use Dynamic M query parameters, read here Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn



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.

Message 2 of 9
437 Views
0
Anonymous2809
Frequent Visitor
In response to parry2k

‎08-23-2023 09:06 PM

@parry2k I got confused does import don't support bind to parameter?

Message 3 of 9
408 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.

View All