Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |