Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

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

Submitted by Anonymous 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

Status: New
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎02-12-2019 06:47 PM

Hi @Anonymous,

 

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

 

q1.PNGq2.PNGq3.PNG

 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable
‎02-15-2019 03:32 AM

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

v-qiuyu-msft
Community Support
Community Support
‎02-21-2019 01:27 AM

hI @Anonymous ,

 

If we set the Status column ahead of the Rating column in SharePoint list settings, the column Status column displays ahead of the Rating column is in Power BI desktop as well. 

Which Power BI desktop version do you run? Please try to update your Power BI desktop to the latest version 2.66.5376.2161 as ours then test again. 

 

Best Regards,
Qiuyun Yu 

Idea Statuses