cancel
Showing results for 
Search instead for 
Did you mean: 

Cannot rename columns in PBI Desktop when using DirectQuery with a PBI Dataflow

I have a PBI Desktop report connected to a series of PBI dataflows. I know DirectQuery supports the renaming of columns but am finding I cannot rename the columns without getting an "This steps results in a query that is not supported in DirectQuery message." There are NO custom steps applied beyond a simple rename step:

PBIIssue.png

REALLY hoping I don't have to rename back at the source dataflow as that will be rather time-consuming as the dataflow processees a large amount of data.

Status: New
Comments
v-robertq-msft
Community Support

Hi,

According to my research, it seems not to be a limitation which is explained in the official document of Microsoft:

vrobertqmsft_0-1632811395722.png

 

And I can rename the columns correctly in my side:

vrobertqmsft_1-1632811395724.png

 

Therefore, I suggest you to update to the latest version of the Power BI desktop and try to republish the report to the service again to overwrite the original report and check if this problem can disappear.

 

Best Regards,

Community Support Team _Robert Qin

arpost
Helper III

@v-robertq-msft, thanks for the reply. That's what my research showed as well. I'm running the Version: 2.97.861.0 64-bit (September 2021), and the error persists. I continue to see that error when I rename a column that is coming from a PBI Dataflow with DirectQuery. Very frustrating.