Skip to main content
cancel
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

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

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

Comments
v-xiaoyan-msft
Community Support
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