sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009
Hi,
Is there any way to get only few years data from a tabular model cube into excel pivot?
(my tabular model has two perspectives and no partitions)
I don’t want to filter the entire dataset in excel, so that I want to get only few years data into excel while loading
If you apply a filter or slicer on the pivot table before adding other members and measures, the query should only return the filtered set from the model. Are you experiencing results that suggest otherwise?
Hi,
Is there any way to get only few years data from a tabular model cube into excel pivot?
(my tabular model has two perspectives and no partitions)
I don’t want to filter the entire dataset in excel, so that I want to get only few years data into excel while loading
Thanks in advance.
If you apply a filter or slicer on the pivot table before adding other members and measures, the query should only return the filtered set from the model. Are you experiencing results that suggest otherwise?