SQL Query from existing imported Table in Power BI

[Anonymous]

Hello,

At this moment I am creating a report where I perform a comparative analysis of attributes to check whether attributes meet certain criteria. This used to be done using an SQL Query when sourcing data and performing the analyses. However, this meant that some data has to be loaded twice due to different checks sharing the same attributes.

My question can I load all the data in once in a table and preforming the checks afterward using SQL queries or am I forced to use DAX.

Many Thanks,

Khalid

[themistoklis]

@Anonymous 

SQL Queries can only be used to load data to tables and also for data transformations(depending on the source database/datawarehouse )during the load.

Once data are loaded to a report then you can only use DAX.

The other option is to use Power Query Editor during the data loading process.

Also you can use python or R coding during the loading process.