Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

dax query when importing data

hi can i use dax query to import data to PBI just from 2016 for example? if yes, how?   thanks a lot
Need Help
MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Greg_Deckler

hi,

 

what do you mean by "year choice"? all the possible year in my DB?

 

and another questions, i wanted to filter in the first place because i can't import all my data to the PBI - says it's out of memory or i am using 32 bit version (i'm using 64bit), actually when i deselect some of my dimensions the data is do imported but still thewre are missing rows

the memory limitiation i deal with, is it because of my computer's memory? or the PBI size limit?

 

thanks a lot

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

This is in the query editor window, so you are only seeing a preview of the data. When you use the drop down arrow in your Year column (assuming you have a year column) you should see a list of all of the distinct values that are in that column and you can select the ones that you want.