Forum Discussion

PowerWhy's avatar
PowerWhy
Icon for Helper IV rankHelper IV
3 years ago

Excel PowerPivot linked to a datamodel with a calculated field

Hi,   I have a powerpivot table that is linked to a datamodel that has a calculated field. I want to be able to filter by the calculated field before the data goes to the pivot table. Please could ...
data protection
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi PowerWhy ,

 

Currently, this is impossible. However, like SQL Server, you can enter the query statement in the following SQL statement before importing to achieve pre-filtering.

So you can import data into SQL Server first and then connect to Power BI.

In addition to pre-filtering through SQL satements, you can also use DirectQuery to reduce the anxiety caused by the size of the data model.

DirectQuery in Power BI - Power BI | Microsoft Learn

 

 

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.