Hi all!
I am not a very advanced Power BI user and I am running into an issue. My report user wants a specific field from our application pulled into a Power BI report. "Great...I can do that easily," I thought. Turns out the field is a function which is not something I have ever dealt with before. This is what shows in Power Query Editor:
How do I get this to show as a table? Basically this is a function for the next date of inspection for a piece of equipment. Obviously I want the next due date autmatically calculated for each piece of equipment, but how do I put in data fields and not static values? I am very confused. Please help!
Hi @SHOOKANSON,
the simples method is the following:
- Fill out some static values.
- Click on Invoke. - pic1
- Now you see a new query among Queries on the left hand site: Invoked Function
- Click on the new query, go to the tab Home and click on the Advanced Editor.
- You see the invocation with all parameters. -pic2
- Copy the invocation from the query and use it whereever you need with new parameters. -pic 3
Hi @SHOOKANSON,
the simples method is the following:
- Fill out some static values.
- Click on Invoke. - pic1
- Now you see a new query among Queries on the left hand site: Invoked Function
- Click on the new query, go to the tab Home and click on the Advanced Editor.
- You see the invocation with all parameters. -pic2
- Copy the invocation from the query and use it whereever you need with new parameters. -pic 3
Helpful resources
FabCon & SQLCon – Barcelona 2026
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Data Days 2026
Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
