Hi,
I use a SP list as a data source for a table visual in PBI. I had it working with a code in the table ie click on a code and it passed the data to the app. However my code was not unique, so it did not read the item I wanted rather the First instance of the code. I thought I'd use the ID of the item to get round this. However I cannot get the function to work. I'm using this
LookUp('List name', ID=First(PowerBIIntegration.Data).Id) and get this error
The expression was intended to look up a row in the 'List Name' table where the ID matches the ID of the first row in the 'PowerBIIntegration' table. However, the errors in the expression are that 'Id' is not recognized as a valid name, and there is an issue with comparing incompatible types (Number and Error).
When I get as far as this LookUp('List name', ID=First(PowerBIIntegration.Data). there is no option to select the ID - so not surprising it doesn't work. All the other columns are available to select. The value seems to be read in as Text, with no option to change it to a number. When i use 'Value' in place of 'First' it still doesn't work.
The ID data card is of type custom. I'm not sure if this makes a difference or not.
I've looked up a few previous questions, and some solutions work for some people, but not others - none for me.
Can anyone gve me some advice on next steps, or even why it might not work.
Thanks alot for your help.
