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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
AshDil
Helper V
Helper V

Exporting Summarized data not working Properly in Power Bi Service

Hi,

 

When user tried to export Summarized data from Power bi report in service facing following issue.

1.When user tried to export data with follwing screen, the Summarized data option is working fine and able to export data to excel.

AshDil_0-1642666479563.png

2. When user tried to export data with follwing screen, the Summarized data option is not working and not able to export data.

AshDil_1-1642666672838.png

 

Please let me know why it is happening like this and help me to resolve this issue.

 

Thanks,

AshDil.

 

2 ACCEPTED SOLUTIONS
v-yetao1-msft
Community Support
Community Support

Hi @AshDil 

The first screenshot is what you get by clicking the export data in the visual in the Service and it works . How about the second screenshot ? What did you do when this page appeared ?

Generally, we control the export data in three places , one in Desktop and two in Service .

Desktop : Options=>CURRENT FILE=>Export data

Ailsamsft_0-1642992964333.png

Service :

Admin portal=>Export to Excel & Export to .csv

Ailsamsft_1-1642992964334.png

Report settings

Ailsamsft_2-1642992964335.png

Ailsamsft_3-1642992964336.png

If you have no problems with these three settings, the export function can be used normally .

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hi @v-yetao1-msft ,

 

Thanks for your reply. The 2nd screenshot is also appearing by clicking the export data in the visual in the Service. When ever the 2nd screenshot appeared, 

User Closes the browser (Google Chrome) > again open the Power bi report in service > clicks export the data from visual > The first screen appears again. It works then.

Thanks,

AshDil

View solution in original post

3 REPLIES 3
v-yetao1-msft
Community Support
Community Support

Hi @AshDil 

I am so glad to hear that your issue has been solved , please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yetao1-msft
Community Support
Community Support

Hi @AshDil 

The first screenshot is what you get by clicking the export data in the visual in the Service and it works . How about the second screenshot ? What did you do when this page appeared ?

Generally, we control the export data in three places , one in Desktop and two in Service .

Desktop : Options=>CURRENT FILE=>Export data

Ailsamsft_0-1642992964333.png

Service :

Admin portal=>Export to Excel & Export to .csv

Ailsamsft_1-1642992964334.png

Report settings

Ailsamsft_2-1642992964335.png

Ailsamsft_3-1642992964336.png

If you have no problems with these three settings, the export function can be used normally .

 

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yetao1-msft ,

 

Thanks for your reply. The 2nd screenshot is also appearing by clicking the export data in the visual in the Service. When ever the 2nd screenshot appeared, 

User Closes the browser (Google Chrome) > again open the Power bi report in service > clicks export the data from visual > The first screen appears again. It works then.

Thanks,

AshDil

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors