Import subset of rows

[hurthsr]

Hi all --

I have a dimensional data mart that, when imported, exceeds the 250mb limit for powerbi.com. I don't typically need all of the data, so I figured I'd just filter out the rows I don't need when I import it. Unfortunately, setting a date restriction on the related 'create date' dimension does not trickle down to the fact table (and associated dimension tables). It appears you'd need to filter every table.

I also tried giving it a query to use for the import, but then it munges all the dimensions into a single list and I'd need to separate by hand -- not a great solution to hand over to a business user.

How do you guys filter out your data?

[PowerBIGuy · Accepted solution]

couldn't you just filter your fact table? There's no need to filter the dimension tables. If your have a fact table with a dateKey for example and you just want to bring in one years worth of data you could add the where clause  "datekey>=20150101" for example. You could also load your data into a Tabular cube . Power BI connects to tabular cubes via direct query so no need to import the data 1st.