Forum Discussion
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...
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)
Thank you very much for the help!