I am currently having a lot of pain with getting data into Power BI. I have a query that I use to get data from a SQL view. When you open Advanced editor when transforming the data you can see the select statement.
Now I thought this would be classed as a native query. But when I right click on the Source step Native Query is not on the context menu?
The query seems to be very slow.
If you open advanced editor you get
Source = Sql.Database(“Instance”,“DB”,[Query = SELECT col1,col2,…coln from v_someview" ,createNavigationProperties = false, CommandTimeout=#duration(0,4,0,0])
This is used against three views each one has circa 5 m rows.
I have no control over the view so I can not change the SQL or remove columns etc. This is why I am using a Query.
Is there a more efficient way to do this?