Need help - need to convert record to table name

[Anonymous]

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. 

What I want is instead of "Record" ( hyperlink ) is that possible that I can have my "table name" (hyper link) which is the first column. So that it will be easy for me to see the table name and click the link to see the details.

Or is it possible to conver all the rows to queries with table name reference.

I have more than 500 rows which I cannot manully convert to separate query or i cannot add 500 queries manually. Because in future more are there need to add. I know Expandfunction is there.

But I want my table names as links or news queries which i can click and see the details about that table. Please guide me on this. 😞 I was struggling for 3 days to do this.

[v-yingjl]

Hi @Anonymous ,

Please try to use this M code to create a custom column like this based on your actual data record:

let tn = [Column1][#"TableName"]
in
Record.Field(#shared,tn)

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@v-yingjl Please help me on this.

[v-yingjl]

Hi @Anonymous ,

Did you want to search the same table in your database and show it in power bi or replace the 'Record' link into 'Tablename' link (the Table name is in the record as your previous said).

Best Regards,

Yingjie Li

[Anonymous]

Hi @v-yingjl , 

I want to replace the "Record" link into "table name" link. OR new column can be created for tablename link also fine for me.

Example: I want "CHRG_DS" in hyper link. So that i will click table name link and see the table details.

In below screenshot Instead of error I want "CHRG_DS". Please help me on this.

[Anonymous]

Hello All,

I did not find the exacr solution. COuld you please help me onthis?

[Anonymous]

Hi Yingjie,

Thank you. I almost get what I want. But getting error 😞 . Since new to power BI i could not find th way to fix it. Please help me.

I just write the query what you have given.  only change I have made is "TableName" to "Table name" ( It is the exact name in my list). But gettning below error. Please correct me.

If i click on record i could see my details. "CHRG_DS" is value of my table name column. I want "CHRG_DS" as my hyper link.

This is the error I got. Filed was not found. 😞

Please help me on this.

Thanks,

Chitra

[SivaMani]

@Anonymous 

Check this video from Guy in a cube - https://www.youtube.com/watch?v=ipI6mrWLQKA

[Anonymous]

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]

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