Forum Discussion

InukBot's avatar
InukBot
New Member
3 years ago
Solved

Power Query-editor and i want to avoid using import mode

First of all, sorry for the bad english, not my first language. I am very new to Power BI and I want to make a map that devides Denmark op into the regions. I was told to use Power Query-editor to g...
Need Help
  • edhans's avatar
    edhans
    3 years ago

    You cannot do it with Number.FromText. That won't fold and only functions that fold can be used with direct import. Off the top of my head I am not aware of a way to convert text to a number and it still fold. Can you have a view written on your server that does that for you first?

     

    For reference, here is a good list of functions and whether or not they fold, which is absolutely necessary for a model that uses Direct Query. The (Almost) Definitive Guide to Query Folding - It's Not About The Cell (itsnotaboutthecell.com)

edhans's avatar
edhans
Community Champion
3 years ago

You cannot do it with Number.FromText. That won't fold and only functions that fold can be used with direct import. Off the top of my head I am not aware of a way to convert text to a number and it still fold. Can you have a view written on your server that does that for you first?

 

For reference, here is a good list of functions and whether or not they fold, which is absolutely necessary for a model that uses Direct Query. The (Almost) Definitive Guide to Query Folding - It's Not About The Cell (itsnotaboutthecell.com)