Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello,
I am trying to get records from a database (ODBC connection) where the documentDate is greater than 1/04/2017.
E.G i have entered this SQL statement...
SELECT Amount, quantity, documentDate FROM SalesLineItem
WHERE documentDate > '1/04/2017'
Data Type from the database
I keep getting errors, for example...... Invalid combination of types compared: DATE and VARCHAR" or Invalid combination of types compared: DATE and BIGINT" if i have the date format as 1/04/2017
This is the format of documentDate in power bi
Any thoughts on how to fix this? have I go the wrong format after the WHERE statement?
Many thanks
Solved! Go to Solution.
The data type was a timestamp and the solution that worked for me is as follws.
SELECT Amount, quantity, documentDate FROM SalesLineItem WHERE documentDate > {ts '01/04/2017'}
Thank you for your input.
It might be safer to format your date a different way.
eg.
SELECT Amount, quantity, documentDate FROM SalesLineItem WHERE documentDate > '2017-04-01'
What is the datatype of the documentDate column in the SalesLineItem table in the database?
The documentDate column datatype is DateTime
Thank you
The data type was a timestamp and the solution that worked for me is as follws.
SELECT Amount, quantity, documentDate FROM SalesLineItem WHERE documentDate > {ts '01/04/2017'}
Thank you for your input.
No, the suggestion did not work. I still get the same errors!!!!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
57 | |
38 | |
36 |
User | Count |
---|---|
81 | |
67 | |
62 | |
46 | |
45 |