Forum Discussion
DB2 validate/format date
Hello: I have a large number of scripts that I am converting from a Viewpoint Sequel format that is using a DB2 connection and converting them to PowerBI. For the most part, I have been able to figu...
Hi leebaldwin ,
Please try to use database native queries when import data from DB2.
For more details, you can read related document: Import data from a database using native database query - Power Query | Microsoft Learn
You could also use "Switch()" DAX function in Power BI
For more details, you can read related document: SWITCH function (DAX) - DAX | Microsoft Learn
Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Unfortunately, I have to use an ODBC connection to our DB2 server, so using native queries is not an option.