Datatype from database ignored when importing data
PBI is connected to a sql view in which one of the columns are explicitely casted to bigint.
After reading in the data, PBI automatically state that the column is a string. This makes my refreshes incredibly slow (column merge, innerjoin etc...). Since I also need incremental refresh and the query must be foldable so datatype change is no option.
How can I force PBI to use the datatype given by SQL and still use native SQL querries?