Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi everyone,
I’ve encountered an issue where the same SQL query yields different results in BigQuery and Power BI. The query includes various aggregations across various tables, and I initially used the GROUP BY ALL feature in BigQuery to simplify my query. However, I noticed that when I run the same query in Power BI (via DirectQuery or importing the data), the results differ from what BigQuery returns. Specifically, Power BI didn't group the data correctly and aggregated the data from two different quarters into the same quarter.
After some troubleshooting, I found that explicitly listing the columns in the GROUP BY clause (e.g., GROUP BY 1, 2, 3, etc.) resolves the discrepancy. This leads me to believe that Power BI might not fully support or correctly interpret the GROUP BY ALL syntax.
Has anyone else experienced this issue or have insights into why this might be happening? I have fixed the issue on my end, but I still wish to fully understand the root cause of the discrepancy.
Thanks for the help!
If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .
Check out the July 2025 Power BI update to learn about new features.