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.
When adding a specific calculated column to a table visual in Power BI I receive the following error when I refresh the data.
The visual is fine upon initially dragging the calculated column over. Once I refresh the data I get the error. I'm using Direct Query with an Azure SQL Server.
Can you not add the calculated column as a part of the SQL Query?
Ideally, you are not allowed to have calculated column in a direct query model.
Hi @ctowery ,
If you can please share some sample data for the test, it is hard to troubleshoot from your snapshot.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |