Forum Discussion

alvenn's avatar
alvenn
New Member
2 years ago
Solved

Retrieving data from a table within a cell

Hi everyone!   I am new to PowerBI and trying to find my way around. I have a problem maybe some of you can solve. I have one main data data source which is a Sharepoint List, let's call it A. This...
Need Help
  • alvenn's avatar
    alvenn
    2 years ago

    Thanks for the answer, but did not work either.

     

    In the end, tinkering a bit I find a solution / workaround. I noticed the "Table" fields have another field with an ID, corresponding to the entry in the table. So I created a new table ("C") and performed a query based on that ID to retrieve the data I was looking for in a column. This also has the advantage of not creating new records in my table "A".

     

    In case this is of interest to anyone, this is the code I created to get the name of the person, stored in Table "B":

     

    Name = LOOKUPVALUE('B'[Name],'B'[Id], 'A'[TEBOberversLookupId])Name = LOOKUPVALUE('B'[Name],'B'[Id], 'A'[TEBOberversLookupId])

     

alvenn's avatar
alvenn
New Member
2 years ago

Thanks for the reply, but no, it is not. It is another List I have with the names and phones of the people.

 

But in any case, I am willing to try the connector suggestion... can I ask how to do so?

 

Thanks!

christinepayton's avatar
christinepayton
Most Valuable Professional
2 years ago

Yeah, you just connect with the same connector but in the connection step where you enter the site URL there is a radio button that lets you select 1.0 or 2.0. 2.0 is a lot faster, too, so it's generally better to use it--