Refreshing Data from SQL Table Function

[mawmawoo]

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 

[amitchandak]

@mawmawoo , field panel means report?

refer

https://www.c-sharpcorner.com/article/execute-sql-server-stored-procedure-with-user-parameter-in-pow...

https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/

[mawmawoo]

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