If at all possible (not a SQL statement person) it would be nice if you could change the data type and have PQ fold that into the SQL statement. There are a lot of cases where data is stored in other formats. For example, we have a General Ledger table where the date is stored as MM/DD/YYYY, but as TEXT! So to do any filtering on it I need to convert to Date, but then that breaks Power BI's ability to continue folding the query as a SQL statement. There are sometimes workarounds, but not always, and it is always a pain.
2 Comments
- Oh, and if this is impossible because it cannot be done in a SQL statement, then please delete this request.
- Status added:Needs Votes
