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 ,

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!