Calculated columns on Shared Datasets not pushed anymore after Power BI Desktop March update

[lbeneyzet]

Good morning,

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.

Can this be researched?

Kind regards,

Lohic Beneyzet

[stefanherven]

The DAX commands seems to be working again when reverting back to Feb release of Power BI Desktop

[stanxl]

@stefanherven How do you rollback? Just re-install Feb release? I have never done that simple thing 😅

[stefanherven]

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

Older versions are available for download here

[DaveT77]

This has broken a number of our dashboards.  Can it be resolved as a matter of urgency please.

[Anonymous]

seems to be resolved on the april version .

[stefanherven]

Yes, the April version fixed my report!

[steveplatz2]

The April version also fixed the issue for me. 

[lbeneyzet]

Good afternoon,

The April 2023 version also fixed the issue for me. 

Thanks a lot. 

THis issue can be closed from my part.

Kind regards,

Lohic Beneyzet

[vishal140197]

I am facing the same issue while using LOOKUP, RELATED, MAXX to create a calculated column in Table A fetching value from Table B. search columns and values are Text Data Type and result colum is Boolean.

Relationship: Table A to Table B - One to Many

Version: 2.126.1261.0 64-bit (February 2024)

[helen_brunyee95]

Same issue here with just a simple LOOKUPVALUE column.