Forum Discussion
Check if query exists
Hi ImkeF,
Thank you, that #shared command is a big step forward.
Unfortunately, * List.Select(Record.FieldNames(#shared), each Text.Start(_, 7)="Invoked") * returns a list of text values, whereas Table.Combine expects tables. I therefore get the following error : "We cannot convert the value "Invoked Function" to type Table.".
I still need a way to select a table from a table name, right ?
Great news for your post, I'll be very interested in reading it !
Antoine
Hi AntoineCh,
sorry, that was a bit quick. You're right, we need to fetch the tables. So it looks like this:
Table.Combine(List.Transform(List.Select(Record.FieldNames(#shared), each Text.Start(_, 7)="Invoked"), each Record.Field(#shared, _)))
That works !
Thank you very much.
Antoine
Hi AntoineCh,
I was a bit surprised to hear that this worked, as I thought you were trying to implement a sort of an imcremental load here :-)
At least with the current PBI version, this doesn't work on my PC, as the freezing of the loaded query doesn't seem to work once they are referenced by the Table.Combine query. Pls let me know if that was your intended strategy and - if it works for you - which version you are using.
(You can find the alternative solution here: http://www.thebiccountant.com/2016/11/15/incremental-load-powerbi/)