cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Irshadn03
Frequent Visitor

BI service - can export to csv but not to excel from report

B979C95D-D48D-42DC-B869-E4A41AAABE95.jpeg

Dear team,

 

i could export to excel and csv before from BI service report but now I can export to csv only ...when i select excel "export" option is inactive.

using pro license. Csv has 30k row limits.

checked setting - export is enabled in BI desktop pbix file.

here is the screen shot.

can any one help ? 
thank you

 

 

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Irshadn03 ,

 

if it worked until now and suddenly it doesn't, I guess the Power BI tenant admin deactivated the export to Excel.

As an admin you can activate or deactivate the export to Excel and CSV separately:

selimovd_0-1633977289561.png

 

Maybe try to get in contact with the tenant admin and ask him to activate the export to Excel.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

4 REPLIES 4
selimovd
Super User
Super User

Hey @Irshadn03 ,

 

if it worked until now and suddenly it doesn't, I guess the Power BI tenant admin deactivated the export to Excel.

As an admin you can activate or deactivate the export to Excel and CSV separately:

selimovd_0-1633977289561.png

 

Maybe try to get in contact with the tenant admin and ask him to activate the export to Excel.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Dear @selimovd 

Thank you so much for your reply and sorry for late response ...
I don't have tenant admin rights , checking with Admin..
"Export to Excel" option limited for Premium users only or is it availble for PRO?
I have Pro license

Hey @Irshadn03 ,

 

yes, please check with the tenant admin.

The option is for the whole tenant, so for Premium and Pro users.

 

But the report author can also disable the download of the data in the report settings.

 

Best regards

Denis

Dear Denis,

 

It is solved, admin anabled the option and now we can export to Excel.

Thank you so much..will close this..

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors