Convert Column from Text to Number in Direct Query

Hi danb,

What if while connecting to a database using DirectQuery you will use NativeQuery, where you can do whatever you want?

See example with CAST(CONVERT) below:

DQ cast

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!

danb,

it acts as a SQL batch (syntax is unlimited). So if you enter a query as I mentioned then it will be send to the database (calculations done on db side) and a result will be returned to Power BI. Use just SELECT statement and you will be safe. 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!