Forum Discussion
dax query when importing data
You would use power query and technically "M" not DAX, but yes. Edit your query or create a new query and connect to your data and in your "Year" column, click the drop down arrow and uncheck everything but 2016. The actual query will look something like:
let
Source = Csv.Document(File.Contents("C:\temp\azureml\SF_Incident_Data_Prepped.csv"),[Delimiter=",", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"IncidntNum", Int64.Type}, {"Category", type text}, {"DayOfWeek", type text}, {"Date", type date}, {"Time", type time}, {"PdDistrict", type text}, {"Resolution", type text}, {"Address", type text}, {"X", type number}, {"Y", type number}, {"Location", type text}, {"Resolved", Int64.Type}, {"Month", Int64.Type}, {"Year", Int64.Type}, {"Hour", Int64.Type}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each ([Year] = 2016))
in
#"Filtered Rows"If you don't see all of your Year choices, you may have a little yellow box that says something like "List may be incomplete" and in that case you click the "Load more" link.
- MP_12310 years agoMicrosoft Employee
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_Deckler10 years agoCommunity Champion
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.
- v-sihou-msft10 years agoMicrosoft Employee
Hi MP_123,
Please check the size of your .pbix file, it has 250 MB limitation.
Please refer to links below:
Power BI Workbook Size Limitations.
Publishing small pbix files, what happens when the data model grows beyond 250 meg after refresh?
Regards,
- MP_12310 years agoMicrosoft Employee
thank you v-sihou-msft
i need to clarify something:
my pbix file can be greater then 250Mb, but the problem begins when i want to publish it, right?