Custom Column shows on Desktop but not on Service

[Tadder]

I have created a custom column [Price Type] using the Custom Column option in Power Query. It's a series of IF statements, and it works 100% in PowerBI Desktop.  However, when I publish to the service, it shows blank...  any suggestions?

= Table.AddColumn(#"Added Prefix", "Price Type", each 
if Text.StartsWith(Text.BetweenDelimiters([price_matrix],"~","~"),"C") = true then "Standard" else
if Text.StartsWith(Text.BetweenDelimiters([price_matrix],"~","~"),"Z") = true then "Strategic" else
if Text.StartsWith(Text.BetweenDelimiters([price_matrix],"~","~"),"T") = true then "Cust Type" else
if Text.StartsWith(Text.BetweenDelimiters([price_matrix],"~","~"),"Q") = true then "Cust Quote" else
if Number.FromText(Text.BetweenDelimiters([price_matrix],"~","~")) = null then "Override" else
if Number.FromText(Text.BetweenDelimiters([price_matrix],"~","~")) = [bill_to_id] then "Cust Contract" else 
if Number.FromText(Text.BetweenDelimiters([price_matrix],"~","~")) = null then "" else "ZZ Contract" )

[KuoTing]

Any news on this topic ?   Is data transformation supported on Power BI services ?

[Tadder]

Hi @v-yulgu-msft and @GilbertQ, thanks for the responses.  I have refreshed the browser, opened in different browsers, etc.  That doesn't seem to fix it.  Also there are filters applied to the report, but none that would affect this column of data.  My dataset is an Enterprise Gateway (not personal) and it shows no trouble signs.  Refresh is running 2x per day and everything seems normal.

Regarding removing and republishing the dataset - That seems to have fixed it, but is that not what happens when I make changes to the dataset in PowerBI Desktop and then publish it?  I get prompted with a "Are you sure you want to overwrite the existing one?" window when I publish. 

I am a big fan of reusing datasets for several reports, but not being able to update/add to them the way I have been throws a giant wrench in my gitty-up.    Perhaps I am doing it wrong?  Is there a way to have only the dataset maintained in Desktop?  From my experience the only way to publish a dataset is to publish a blank (or not blank) report along with it.  Is there something I'm missing?

Anyway, thanks for the assist!

[v-yulgu-msft · Accepted solution]

Hi @Tadder,

 Please try to refresh the browser or click the Refresh button on report page to see if data is loaded. Also, please try to remove and re-publish this report file to see whether it works.

Best regards,
Yuliana Gu

[GilbertQ]

Hi @Tadder

I know this might be something that you have looked at, but in the Power BI Service are there any filters on the visual, page or report level?

Also is your data connected to an On-Premise or Personal Gateway?