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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
bhavadharani
Helper I
Helper I

Issue in connecting excel pivot table and power bi

Hi.. Hope all are doing good

I connected Excel pivot table with power bi through get data. I had no issues in connecting power bi and Excel, but I faced issues while loading the Excel Pivot Table data into visualization(data is broken and rows and columns are mismatched while loading into visualization). 

Please help me to solve my problem.. Thanks in advance 🙂 

2 ACCEPTED SOLUTIONS
amitchandak
Super User
Super User

@bhavadharani , Prefer to load the data, not pivot. Pivot data is already aggregated, so new visual aggergation will be on top of it.

In such a count, there will be a sum here.

distinctcount will sum and may not match.

 

edit

In between, also noticed same issue on snowflake. Better check and log an issue too, if needed- https://community.powerbi.com/t5/Issues/idb-p/Issues

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Hi,

No you cannot.  You can only load the Data Model and/or query Tables into PowerBI Desktop.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Share the 2 files - Excel and PBI and clearly show the problem.  Also, show the expected result there.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Hi @Ashish_Mathur 
Can we load pivot table in Power Bi 

Hi,

No you cannot.  You can only load the Data Model and/or query Tables into PowerBI Desktop.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
amitchandak
Super User
Super User

@bhavadharani , Prefer to load the data, not pivot. Pivot data is already aggregated, so new visual aggergation will be on top of it.

In such a count, there will be a sum here.

distinctcount will sum and may not match.

 

edit

In between, also noticed same issue on snowflake. Better check and log an issue too, if needed- https://community.powerbi.com/t5/Issues/idb-p/Issues

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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