unable to expand lookup columns from sharepoint online list

[mudegowdrp]

I have connected sharepoint online list which has few lookup columns but in power BI I am not getting any data if I try to expand lookup column. Please help.

Thanks

Pooja

[v-shex-msft]

HI @mudegowdrp,

How did you create lookup columns? I think power bi may not support these type of columns.

Can you please share some detail contents about this?

Regards,

Xiaoxin Sheng

[mudegowdrp]

@v-shex-msft I have lookup columns in Sharepoint Online List which I need to retrieve in Power BI but I cannot do it

[v-shex-msft]

HI @mudegowdrp,

I'm not so sure why your columns can't be recognized, can you ensure you are using support types?

Data types in Power BI Desktop

Regards,

Xiaoxin Sheng