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.
We have loaded huge volume of data(> 1M) from database into PowerBI through ODBC connection.
Need to create a custom column based on if-else-if statement with several and conditions . I have used Custom column option but once I apply changes , the report is again hitting DB for loading data which is taking lot of time.
Is there any other alternative where we can prevent report refreshing data from database.
Thanks !
Solved! Go to Solution.
@Anonymous , In power query it will. In DAX you can use Switch, bit costly but will work with loaded data
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
Hi @Anonymous ,
You could try unchecking the Enable load option before creating custom column and enable it after the columns being created.
Best Regards,
Jay
Thanks worked as expected
Hi @Anonymous ,
You could try unchecking the Enable load option before creating custom column and enable it after the columns being created.
Best Regards,
Jay
@Anonymous , In power query it will. In DAX you can use Switch, bit costly but will work with loaded data
Switch-Case statement of #PowerBI: https://www.youtube.com/watch?v=gelJWktlR80&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=56
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 |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |