1

I need that user could specify a specific date and the report would refresh from data source to show it. It could be chosen from a calendar, date picker or simply by writing down a date in the field as a string. The problem is that the data can't be loaded and then filtered. It has to use this chosen date in the SQL query, which would allow to recalculate data. Users are Power Bi PRO and uses the cloud version. Would it be possible?

Improve this question
2

1 Answer 1

Reset to default
2

As Sam Nseir suggested you can use Dynamic M query parameters, you can check the following question that seems to be similar to yours:

How to change the power query parameter from the Power BI Interface?

A part from MS the reference given by Sam Nseir you can check this article that can be helpful:

https://blog.crossjoin.co.uk/2023/01/29/passing-any-arbitrary-value-from-a-power-bi-report-to-a-dynamic-m-parameter/

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.