Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I can refresh the Data from SQL Table Function with Date parameters through "Power Query Editor" by providing new Date Value.
But I want end users to refresh the data from same SQL Table Function through "Field Panel".
Is it possible as I cannot figure it out?
Thanks in advance.
Maw Maw
@mawmawoo , field panel means report?
refer
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
Hello Amitchandak,
Yes, want to see it in field panel of report.
Thanks for the Parameter Value related information.
I managed to setup Date parameters to run the Table-valued Function in Power Query Editor environment. It will generate "Invoke Function xxxxxx" as below.
But in the "Report Environment" it will only show the "Invoke Function xxxxx", not actual function for user to select NEW DATES to refresh the data. I want user to select date from parameters ro generate new set of data.
Cheers,
Maw Maw
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |