Forum Discussion

thiagozaiden's avatar
thiagozaiden
Microsoft Employee
10 years ago
Solved

Filter Analysis Services before Importing Data

Hello guys,

 

I have a very big cube that has data from all over the world, but I only need one specific country.

I could import everything and then filter it, but since its too big, I keep getting and error message whenever it passes 10 million rows loaded, saying it ran out of query time.

Is there a way to filter before importing?

What is the cause of this error? Memory? Network? Capacity?

 

Ps.: I can't use live data because I already have other sources in this Power BI file, so only Import option is enabled.

 

Thanks!

  • Use "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.

4 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Use "Advanced options" when creating your query and paste in your MDX to filter the data at the time of query.

      • Anonymous's avatar
        Anonymous
        Not applicable

        What's the MDX code to filter it?