Hi Folks,
I have a function that calls a simple sql query to get 1 row based on the value in a column.
"= ( somenumber as number )
=> let
numberasastring = Number.ToText(somenumber ),
Source = Sql.Database("server", "database", [Query="SELECT TOP 1 * FROM DB WHERE " & numberasastring & "= thenumberinsql"])
in
Source"
This is fairly slow (40 records per second or so, and the SQL Server is mostly idle the whole time) but it does work, however I seem to have issues where the queries just stop executing all together after loading for some time.
Ive connected SQL Profiler to powerbi desktop to try and see whats going on, but its just not doing anything.
Is there some other best practice for getting row level data from SQL for each row in a table in powerbi?
