Power Query (Desktop): unavailable Group By button, missing File menu, no quick access bar
Hello
With the latest update (sep/24) of Power BI Desktop (My version is: 2.136.1202.0 64-bit) I have several issues in Power Query
First, the Group By button is unavailable in ANY case
(Of course, I can do grouping with the M function, but...)
Second, the File menu is missing. Really, I'm not sure if this is an issue but in any case I don't have the Save button, for example
And last (at the moment), I've lost the quick access bar . And of course I can't add any button to the quick access bar.
(A few days ago, I had the same problems. I checked the version and it said October/24 😳. But later, it was automatically reversed. But now again I have the same issues)
Thanks in advance for your help and attention
11 Comments
- davidfelipepgFrequent Visitor
And additionally I have seen that, when I have a list or a record object, I don't have the specific list/record menu
- Tommy88Regular Visitor
same here
after update Power BI Desktop September 2024
Group By button in PBI-Power Query greyed out - AnonymousNot applicable
How did you update your PBI Desktop ? Did you update it inside the Microsoft store or did you download the latest installer through Download Center to update it? Have you guys tried uninstalling the original program and re-downloading the installer to update it?
Best Regards,
Community Support Team _ Ailsa Tao - davidfelipepgFrequent Visitor
Hi, Anonymous
Thanks for your answer
I don't manage the updates. I have a business account of my company and it updates automatically.
I didn't try to re-install becuse I guess it will be re-updated again and I guess this wrong behaviour is a programming bug
If you need more information, please ask me again
Best Regards,
David F. Peña
- s_wolfe99New Member
same issue here with the 'Group By' function in Power Query.
Group By button in PBI-Power Query greyed outI verified I am on the latest version (september 2024 release) - Update was installed automatically
- s_wolfe99New Member
I found a work-around for the 'greyed out' group by function in Power Query so figured I would share.
The function is greyed out in the ribbon, but you can still right click on a column header and select "Group By".
It brings up the normal group by dialog and allows basic and advanced grouping.
- davidfelipepgFrequent Visitor
Thanks a lot s_wolfe99
I've seen that option too. But nevertheless thanks for sharing.
(although still some other issues with the PQ's ribbon)
Have a good day
- BrunoBougleuxNew Member
I have the same issues at my company. We use the company's portal to update powerbi and downloading from official site (x64) and the end still the same.
Waiting for explanation or fixed update. - AnonymousNot applicable
We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient!
Best Regards,
Community Support Team _ Ailsa Tao - davidfelipepgFrequent Visitor
Thanks a lot for your response Anonymous . I'll be patient. No problem.
We have alternatives for the Group by button on the ribbon and for the missed specific menus for lists and records. But for me, the quick access bar is more important and useful. And don't forget please the missed the File menu too
Best regards, David