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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mawmawoo
Regular Visitor

Refreshing Data from SQL Table Function

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 

2 REPLIES 2

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.

 

PBI-QueryEditorEnv.jpg

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.

 

PBI-ReportEnv1.JPG  

 

Cheers,

Maw Maw

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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