Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ChristianCorah
New Member

Discrepancies Between BigQuery and Power BI Results When Using "GROUP BY ALL"

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!

 

1 REPLY 1
lbendlin
Super User
Super User

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 .

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Kudoed Authors