Forum Discussion

Jase71ds's avatar
Jase71ds
Advocate I
2 years ago
Solved

Power Query (ONLINE VERSION) Don't Change Type

Hi, I deal with Text values that look like "01.01", "06.10", "09.18", "20.10" etc, that break reports if converted to Decimal.   In PBI PQ (or Excel PQ), I have an option to not have it "Detect Ty...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    2 years ago

    Jase71ds I am not aware of any settings in the service that provide the same options as in Desktop for this. It just doesn't exist. 

Jase71ds's avatar
Jase71ds
Advocate I
2 years ago

Thanks for your input. Yeah, I combed through all the menu options and didn't see anything.

After I posted this, I decided that at minimum, I can let it change the Type to Decimal up front, do my thing, and then at the end go delete that step. Just have to remember to do.

 

Thanks again.

Hope they add that feature soon. It's a case of PQ trying to be too helpful 🙂