Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

0
alcas

Semantic Model Filtering in PBI Table (not Pivot Table) in Excel

Submitted by Microsoft Employee on ‎11-04-2024 03:53 PM

Hello,

 

I need to edit a TABLE in Excel-based models that is connected to a fabric semantic model regularly.  The user experience upon initial connection is great, but it does not exist for EDITING the connection - that can only be done by updating the DAX query. This is not user friendly, especially for those that are primarily working in Excel-based models, not at all familiar with DAX.

 

Is there anything in the roadmap for the initial user experience (GET DATA --> FROM POWER BI  ---> FROM POWER BI DATASET --> INSERT TABLE) to be accessed again for subsequent updates to the table?

 

Need the ability to easily add/remove/refresh fields, filters, etc. 

Status: Delivered

Hi  @alcas ,


From the information I found, there doesn't seem to be a specific roadmap item that directly addresses the ability to access the initial user experience for subsequent updates to the table.If you would like a more user-friendly way to edit tables in Excel-based models that are connected to a fabric semantic model, without having to update the DAX query manually. You may raise an idea here to improve this feature. It is the right place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

See more ideas labeled with:
1 Comment (1 New)
Comments
v-xiaoyan-msft
Community Support
Community Support
‎11-04-2024 05:15 PM
Status changed to: Delivered

Hi  @alcas ,


From the information I found, there doesn't seem to be a specific roadmap item that directly addresses the ability to access the initial user experience for subsequent updates to the table.If you would like a more user-friendly way to edit tables in Excel-based models that are connected to a fabric semantic model, without having to update the DAX query manually. You may raise an idea here to improve this feature. It is the right place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

Idea Statuses