Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help - need to convert record to table name

Hi,   I am new to Power BI. I have imported JSON file into Power BI. I have list of records.                    If I click on any record I can see the values inside the record.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks Siva. I have seen this vedio. But my problem is different. If I click "record" under list I could see the details. Instead of "record" I want my table name in that place. I want to click my tablename and see the details inside that. Is that possible? I know expandfunction is there. But i do not want as table format I want as list format with my table names. Could you please help me on this? 

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Use the Record.Field() function in query.  The first term would be your column with the records, and the second would be the name of the field in the record that holds your table name.  You can preview the record below by clicking to the right of the "Record" hyperlink.

 

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat