The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
I work with the SDK of Visual Studio for Power Query in M.
I have a function, that make request to api of anaplan and returns the table with values. When I test it in visual studio, I receive the table with 3 rows. When I build the extension and use it in Power BI, I always get list with one value. What am I doing wrong?
Hi @Anonymous
If you create a new query in power query for "Api.RequestExport", then enter single value and invoke, you could only get one row for values each time.
You could create a table with "workspace id","model id", "field id" firstly, then invoke the query "Api.RequestExport" inside this table by "Add column"->Invoke custom column".
You could refer to the following:
https://blog.crossjoin.co.uk/2016/10/01/using-the-invoke-custom-function-button-in-power-bi/
If you're in other cases, feel free to let me know and show how you use queries in Power BI.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.