Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Expand Column Type Table - Source SharePoint List

Hi All,

 

Source for my Power BI Report is SharePoint List.

 

While loading the data i am getting few columns in the form of Table. 

 

Table.PNG

When i click the double Arrow in the top Right it shows nothing.

 

Table1.PNG

 

How to expand that or How to Make that table as a column?

 

Please help me on this.

 

Thanks in Advace

Prakash

3 REPLIES 3
v-yuaj-msft
Community Support
Community Support

Hi @Anonymous ,

 

When you in the "Navigator" page, could you see the hidden columns in Preview of the table?

v-yuaj-msft_0-1617090058443.png

Best Regards,

Yuna

 

PC2790
Community Champion
Community Champion

Can you provide the Advance Editor M code for the applied steps?

Anonymous
Not applicable

Hi @PC2790 ,

 

I am not doing anything apart from pulling it from SharePoint Site.

 

Adva Edit.PNG

However i have Hided the SP Site Name and Source code from the above screenshot.

 

Regards,

Prakash

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.