cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
Eriksonbh
Regular Visitor

Data export (Excel)

Hi!
I have a certain file that I can't get the export options to appear. I can get all the other files, but my main one, I can't...
All export options are enabled, so much so that the rest work fine.
Does anyone know what could be happening? It is SQL data and is a file created in 2019.

 

Eriksonbh_1-1695394981560.pngEriksonbh_2-1695395034802.png

Eriksonbh_3-1695395127624.png

 

 

1 ACCEPTED SOLUTION
Eriksonbh
Regular Visitor

After a lot of searching, I found the problem. It's in the file settings within the Workspace. At some point, it got marked for hiding.

Eriksonbh_0-1695675997143.png

 

View solution in original post

6 REPLIES 6
Eriksonbh
Regular Visitor

After a lot of searching, I found the problem. It's in the file settings within the Workspace. At some point, it got marked for hiding.

Eriksonbh_0-1695675997143.png

 

Eriksonbh
Regular Visitor

That's exactly the problem! The menu does not appear in any of my visuals. I don't even know if it's possible to hide... I've never seen that option.

They're in the "general" tab for the visual - you can toggle all or specific ones piecemeal:

christinepayton_0-1695655479877.png

 

Hi, Cristina!
Icons are not hidden. In PBI Desktop they appear normally.

Could the problem have to do with RLS? We work with this parameter...

Eriksonbh_0-1695666550082.png

 



RLS wouldn't do that, hmmm... you could check in the report settings in the desktop vs in the web - they are not always the same between the two, meaning it could be enabled in the desktop app but disabled in the web report settings.

 

You might also try creating a new table with the same data on a test page and see if you have the same problem there (publish to your personal workspace if you don't want people to see it) - that will tell you if it's a report issue or a visual issue. 

christinepayton
Solution Sage
Solution Sage

Have you hidden the header icons in the visual settings? I don't see the ellipsis menu in your screenshot. The visual export requires the header icon menu to be enabled to get to it-- 

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors