Test in power query SDK and in Power BI returns different results

[Anonymous]

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?

[v-juanli-msft]

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.