0 Kudos

When connecting to SharePoint online list, the list columns does not come in same order in Power Bi

Status: New
by ankku Member on ‎02-11-2019 06:30 AM

When connecting to SharePoint online list, the list columns does not come in same order in Power Bi as in SharePoint. For example if I have column in SharePoint as Title, ID , Status, Rating... After importing to Power Bi i see the list has column in Order like Tile, ID, rating and Status.

Why is that so? is this the normal behaviour??

 

Thanks

Comments
by Moderator v-qiuyu-msft
on ‎02-12-2019 06:47 PM

Hi @ankku,

 

I would suggest you check the Column Orders setting for the SharePoint online list: 

 

q1.PNGq2.PNGq3.PNG

 

 

Best Regards,
Qiuyun Yu 

by ankku Member
Friday

Hi @v-qiuyu-msft 

 

 

That has already been checked and it seems to be default behaviour. The column ordering is not mapped in power Bi. It s completely different. Please check if you see the same issue, and something we can suggest as an idea. Thanks,

ankku

Idea Statuses