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.
I have a calculated column which filter data on the basis of other column. the calculation is working fine in import mode of source but failing in direct query mode.
Can anyone please suggest a workaround?
Solved! Go to Solution.
Hi @ElevonTeam,
>> the calculation is working fine in import mode of source but failing in direct query mode.
Current there are a few limitations to use calculation in directquery mode, so you can't use calculated column to achieve your requirement.
Reference link:
>>Can anyone please suggest a workaround?
In my opinion, I'd like to suggest you use measure to instead.
Regards,
Xiaxoin Sheng
Hi @ElevonTeam,
>> the calculation is working fine in import mode of source but failing in direct query mode.
Current there are a few limitations to use calculation in directquery mode, so you can't use calculated column to achieve your requirement.
Reference link:
>>Can anyone please suggest a workaround?
In my opinion, I'd like to suggest you use measure to instead.
Regards,
Xiaxoin Sheng
I have create a sample Power BI report which connect to SQL Server database by using DirectQuery mode, and then create a calculate column. I can use this column in Slicer and use it to filter data without any questions.
So could you please provide us more detail information, so that we can make further analysis. You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.
Regards,
Charlie Liao
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |