After Power BI Desktop March update, we are experiencing error message "Column [X] cannot be pushed to the remote data source and cannot be used in this scenario". When the report is opened on Februari 2023 Desktop, it works, in March 2023 desktop it gives an error.
The calculated column contains the DAX function "today()". A calculated column like 'New Calculated column = 1' works. But with DAX Fcuntion Today() not.
We have reported this issue and submitted it to the product team. They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient.