Forum Discussion

pinar1's avatar
pinar1
Frequent Visitor
5 years ago

Getting Sharepoint List Data with the Same Row Order

Hi PowerBI community! 

 

As I am trying ti get data from Sharepoint List, I want the rows to stay in the same order. However on PoweBi , all the rows got mixed up. Does someone know how to fix this issue? I can not recreate the sorting on Power Bi because there is manual sorting going on the list. 

 

On sharepoint: 

 

 

But On Power Bi: 

 

CategoryIssue
TravelIssue K 
ShipmentIssue D
TravelIssue C
ShipmentIssue A
ShipmentIssue B
Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    pinar1 , how does order matter. In visual you can sort on category. To me they seem to be in the correct category

    • pinar1's avatar
      pinar1
      Frequent Visitor
      5 years ago

      By row order I mean the row sequence . I want to see the data on Power Bi as this (in the similar row sequence as on sharepoint site): 

       

      CategoryIssue 
      ShipmentIssue A 
      ShipmentIssue D 
      ShipmentIssue B 
      TravelIssue C 
      TravelIssue K 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi pinar1 ,

    For my test, the Category column will be sort automatically. And according to my understang, you want to sort Issue column as the same as the original ,right?

    Maybe you could add a Index column in original data source then select Sort by Index in visualization.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please upload some insensitive data samples and expected output.

    Best Regards,
    Eyelyn Qin