modify a query when using import data.

[beamex]

modify a query when using import data
Hi. I have created a dataset that get imported into PowerBi via our gateway.
Now i use the modify query function within powerbi desktop to add two now columns that are a modified copy of two other columns.
These two columns are working great when in powerbi desktop, but publishing the report these two columns does not exist online.
Is this as designed or do a do anything wrong or do i have to switch to using direct queries.
If this is not possible at the moment i will do another post as a feature request.
I have not been able to find a solution yet for this.

[v-qiuyu-msft · Accepted solution]

Hi @beamex,

From your description, it seems that you add two columns in Query Editor, and these two columns doesn't display after publish to the Power BI service, right? 

In your scenario, please make sure you apply the change and load these two columns to data mode. You can go to the Data tab check if new columns exactly exist. Also make sure "Hide in Report View" isn't be checked. 

Best Regards,
Qiuyun Yu