PowerQuery conditional column breaks scheduled refresh

[alowen]

Hello! I have a pbix that runs queries against Active Directory. When adding a conditional column via the PowerQuery editor it seems to break scheduled refreshes. All the conditional column does is look at the AD title column and search for specific strings of text and if found, drops it into the new column. 

#"Added Conditional Column" = Table.AddColumn(#"Replaced Errors11", "Vendor", each if Text.Contains([organizationalPerson.title], "Vendor1")
then "Vendor1" else if Text.Contains([organizationalPerson.title], "Vendor2")
then "Vendor2" else if Text.Contains([organizationalPerson.title], "Vendor3")
then "Vendor3" else if Text.Contains([organizationalPerson.title], "Vendor4")
then "Vendor4" else if Text.Contains([organizationalPerson.title], "Vendor5")
then "Vendor5" else "Other")

As soon as that column is added i get the following error: You can't schedule refresh for this dataset because the following data sources currently don't support refresh.

Is this just an unsupported feature? If so, is there an alternative method that would work with scheduled refreshes?

Thanks!

[alowen]

Yes, table loads without issue. And, as you mention, there's no source of the error listed after the error message.

Interestingly though, I checked and the dataset DID refresh overnight as it was scheduled to do before this error appeared. I can't make any changes to the refresh schedule, but it does appear to be working.

[otravers]

That table loads in Power BI Desktop without issue with the conditional column, correct? We've seen these weird error messages lately like the one you posted where there's no actual source listed below it. Clearly a bug that seems to randomly come and go.

If you really can't get the dataset to refresh with your conditional column, I'd try to move that query to a dataflow and see if it refreshes there.