Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

arpost

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

Submitted by Post Prodigy on ‎09-27-2021 04:54 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
v-robertq-msft
Community Support
Community Support
‎09-27-2021 11:43 PM

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
Post Prodigy
Post Prodigy
‎09-28-2021 09:56 AM

@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.

Idea Statuses