Unable to extract the multi filed value from SharePoint Online in Power Bi

[sivaksk147]

Hi team,

I am trying to fetch data from Sharepoint online list, all the value I can extract, but whichever the values show as "Table" I am not able to extract it shows No columns found. Please suggest how to fix this issue. 

Screenshot for your reference

[v-xuding-msft]

Hi @sivaksk147 ,

Baed on my test, it will show all the data unless it is empty originally in my sample.

Can you please share some details?

• Do you check if it is empty in SharePoint Online? What should the Services column be like?
• Is the table that you shared a entire table in SharePoint Online? Or you select several tables but it changes to one table when you import to Power BI?
• What is the table in SharePoint Online like? You could create a sample to show or you can take a screenshot and mask the sensitive data.

Best Regards,

Xue Ding

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

[sivaksk147]

Any help team? 

[sivaksk147]

Hi Xue Ding

Sharepoint Online values are not empty, it has the value, attached screenshot for your reference.

Sharepoint Online have selected Multiple List which is used in lookup columns with multiple value selection, attached is screenshot for your reference

it works well with single value selectin if I enable multiple values it does not work.