Microsoft
MicrosoftSo far refresh from authenticated data source has limited functionality, in particular
On the other hand that's very early Beta, hope one day it'll be more advanced implementation.
MicrosoftThanks for the feedback, SergeiBaklan !
About combining data source and privacy options - correct, we plan to add this when we release the PQ Editor (soon after authenticated refresh reaches GA).
About gateways - correct, this requires extensive work, and we are investigating it.
Regarding your last bullet - could you share examples? Feel free to message or Email me.
Thanks!
jokahati, I created small query which imitates lists structure returned by OData feed. In both added the column which calculates lists length
let
SampleTable = #table(
type table [Lists = any], // intentionally type any, not List.Type
{ {{[a=1], [a=2]}}, {{}}, {{[a=3]}} } ),
ListsLength = Table.AddColumn( SampleTable, "Length", each List.Count( [Lists] ), Int64.Type)
in
ListsLengthand for the feed
...
PrevStep = ... ,
ListsLength = Table.AddColumn(PrevStep, "Length", each List.Count( [Lists] ), Int64.Type )
in
ListsLengthNext refreshes both in Excel Desktop and Excel for web
As you may see Excel for Web doesn't recognize lists returned by OData as lists and not sure what exactly List.Count() returns. Further expanding gives
Expression.Error: We cannot convert the value "[List]" to type List
Above OData query works correctly in Power Query online, Power BI Desktop, Excel Desktop. Similar query works for anonymous OData feed I found on the web.
MicrosoftHey, we were unable to repro this - if possible, please share/message/email me with a file with a similar structure.
jokahati , thank you for the update. Step by step we are closer to the result.
I can't share the file with the example, that was OData feed from accounting system. But I'll try to create some sample, if able to reproduce the problem will share with you.