Skip to main content
Microsoft Idea

Power BI

Needs Votes

Ability to replace values in DirectQuery

Vote (15) Share
Scott A's profile image

Scott A on 31 Mar 2016 21:49:53

A competitor--Dundas BI--gives the user the ability to transform data without the need to import the data. This is possible because there is a database backend for Dundas BI.

I would love to see this ability in Power BI Desktop--the ability to make transforms using DirectQuery that doesn't actually manipulate the data source. Specifically, I'd like to be able to use the "Replace Values" in DirectQuery to make some of my data more meaningful.

Comments (2)
Scott A's profile image Profile Picture

Power BI User on 05 Jul 2020 23:59:15

RE: Ability to replace values in DirectQuery

Yeah, I need this. Like now.

Scott A's profile image Profile Picture

Garrett on 05 Jul 2020 23:58:01

RE: Ability to replace values in DirectQuery

wild this still doesn't work