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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors