Problem statement: If users of your PBI report want to export data:

1. You need to enable the visual header icon - more options for each visual your want users to be able to export from.
2. Further more, users will be able to export fields only available in that visual.
3. Additionally, if the visual is not a table or a matrix
   1. You have no control over column headers of exported data, they will show your Fields/measures names.
   2. , If you have dynamically formatted measures, you will get a column containing the format string exported for each dynamically formatted measure.

Better Approach:

Create a visual dedicated ONLY for data export and put in it all what you think your users might need to export and make its fields dynamically selectabel! Here is how...

1. Create a Field parameter and include in it all your tables columns and measures you think users might need to export, let's name it Export, and the parameter column name is Value.
2. Create a slicer using Export[Value].
3. Format the slicer setting Style to drop down and selection to Single Select (off) and Multi-select with CTRL (off). This will make the fields selectable via check boxes.
4. Create a table visual also using Export[Value].
5. Switch off the text wrap from the table values and table column headers.
6. Set the table title to "EXPORT".
7. Shrink the table column widths to be all zeros, and the table hight to be just accomodating the title.
8. Layer the slicer to be on top of the table using the selection pane.
9. Ensure that header icons are switched off for the slicer and all other visuals, and switched on only for the table with only "more options" icon selected
10. Group both visuals

Now your users can use the slicer to choose all the fields they want, then click on the ellipsis and export these fields to an excel file.

Note that:

1. You have full control over the field names using the Export[Value] column in the field parameter table.✅
2. User has full control over what they want to export.✅
3. Exported data will be reflecting all user applied selections and filters.✅
4. Bonus tip: in the parameter table you can add one more column to categorize the fields and use it in the slicer to group similar fields under a category.✅

Will look amazing 🌟

The latest Power BI release confirms a clear direction: deeper AI integration, more flexible modeling, and smarter distribution.

The most impactful changes include:

AI at the Core: Copilot now generates DAX measure descriptions automatically and delivers filter-aware summaries, even in standalone mode.

Flexible Distribution: Org Apps in Pro Workspaces (Preview) enables tailored report experiences for different audiences from the same workspace.

Modeling Without Limits: Direct model editing in the service, native SQL queries in-browser, and expanded Databricks Direct Lake integration.

Better Connectivity: Updated Impala connector, Entra ID authentication for PostgreSQL, and streamlined PBIP format.

Microsoft is accelerating the shift toward self-service analytics powered by AI, while ensuring enterprise-grade modeling and connectivity. For organizations, this means faster insights, cleaner documentation, and a more personalized reporting experience.

Hi:

I'm sharing my experience with this problem, which it took me a couple days to solve, in hopes that it can be helpful to anyone.

I was writing report summaries with the functionality that allows you to add dynamic values (like, ad hoc DAX and AI-generated measures) to text boxes when, one day, it suddenly stopped detecting my measures and I couldn't add them anymore.

I couldn't understand why this was happening. They were clearly available in the model, but not showing up inside the text box visual, eventhough they worked perfectly in other visuals, like Cards.

I tried all the tricks I could think off or find online: restarting Power BI, duplicating the .pbix file with a different name, clearing PBI's cache, using an earlier version of the file, asking a colleague to see if it was a problem with my PBI version, recreating some measures… but none of it worked.

💡 Eventually, I found the key: the issue was related to the Q&A visual and its natural language engine, which is also used under the hood for the Add-a-dynamic-value (+ Value) functionality within text boxes.

✅ Solution:

1. Go to Modeling > Q&A Setup > Synonims.
2. Disable as many tables as possible in that view.
3. Close the dialog box and wait for the changes to apply.

After doing this, PBI immediately started recognizing my measures inside the text box (and also in the Q&A visual, which I was not using in my report, but I tried as a result of this issue).

🧠 Why does this seem to happen?

The Q&A visual shares the same natural language engine that powers dynamic values in text boxes (basically, Copilot). If there's an issue with how the semantic index handles your tables or measures, it may prevent new measures from being recognized properly. In my experience, this tends to happen in models with too many tables and/or measeures (in my case, I had 700+ measures when I detected the issue).

I couldn’t find this solution anywhere in the forums or online, so hopefully this saves someone else a lot of time — it took me nearly two days to figure it out.

Cheers.

Button Slicer / How to Make Images as Slicers in POWER BI ? Solved! Example HR Dashboard 

There is an interesting functionality inside the Power BI Service in which a user can create an alert about a required numeric rule within a visualization. This will give them an early notification about a business process or allow them to keep up to date about specific situations at the exact moment that they occur. In my opinion, the alerts are only comfortable if you have the mobile app, due to instant notification, like a text message, instead of getting an email. Emails are not always checked right away.

The issue here is that all these configurations are only for the user that configures it. However, what can we do when we want to notify other users about the alert created? Power BI won't let you configure another email or user to get this notification. For this reason, we are going to use Power Automate (formerly known as Flow)

Original post from La DataWeb.

Being an analyst with modern visualization technology is fun and enriching. Who doesn’t enjoy a stunning visual with useful and easily consumable insights? The reality is: even the most thoughtful authors have blind spots. Why? Because authors have significant amount of background knowledge that is not carried through via visualizations. In the absence of that, users relay on visual cues and the knowledge they learn from elsewhere to interpret what they see. This often cause communication gaps in data visualization, particularly in situations where report is authored by one person and used by many users from different teams, different backgrounds, and have different background knowledge and chart reading abilities.