Forum Discussion

JoK's avatar
JoK
New Member
2 years ago
Solved

Issue with the group ranking in Power Query (April 2024)

Hi Power BI users, I have a problem with Power BI transformations (Power Pivot) that affects the connectivity to SharePoint. It worked in previous version and after recently upgrading to April 2024 I...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JoK ,

    After testing, I have successfully reproduced and confirmed the issue. it looks like the previous known issue was not fixed.
    I would recommend that you start with SharePoint Online connector implementation 2.0 or roll back your version of Power BI Desktop to the February version (as this issue occurred with both the March and April versions). I'll keep you posted as soon as this issue has any updates.

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JoK ,

Have you solved your problem?
If not, can you tell me whether your dataset is the Sharepoint (Online) List or the Sharepoint Folder? And whether you are using SharePoint Online connector implementation 1.0?
We had a known issue similar to what you are facing, but that issue occurred in March. Could you please provide me with more detailed information so that I can test it further?

Best Regards,
Dino Tao 

JoK's avatar
JoK
New Member
2 years ago

Hi Dino, 

Thank you for your response. Yes, we still have this issue. 

I am connecting to Sharepoint (online) list. The connector implementation is 1.0 as that was the one that worked in the past. Do you think it s worth trying 2.0?

The Power BI version that I am currently running is: 2.128.952.0 64-bit (April 2024)

 

Many thanks, Jo

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    How many lookup columns in your list?

    • JoK's avatar
      JoK
      New Member
      2 years ago

      Hi, there is no lookup columns used in that list.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        2 years ago

        have you raised the ticket?

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JoK ,

    To make it easier for our engineers to solve the problem, I need to gather some information.
    First, roughly when did this problem start happening?
    Second, why are you using SharePoint Online connector implementation 1.0 instead of SharePoint Online connector implementation 2.0?

    Thank you for your cooperation!

    Best Regards,
    Dino Tao

    • JoK's avatar
      JoK
      New Member
      2 years ago

      Apologies for late reply and thank you for looking into it! We use the older connector 1.0 as the issue was noticed once redeveloping an older dashboard (we have a very large number of already existing reports). We only discovered it few days before I posted - I guess would be related to updating to more recent Power Bi version. I have checked and updating connector to 2.0 version fixed the issue for us.  Thank you!