Forum Discussion
Pasting complex SQL query into Power BI
I have been using Toad Data Point to query a large Vertica database with a query given to me by a peer. The query is a rather frightful mixture of joins and window functions that mere mortals like me...
Anonymous wrote:EVE, If I did that, I would have to run the server-side query each time I wanted to use the dashboard, wouldn't I?
That's not very user-friendly, is it? Telling my users, "hey, before you go to powerbi.com for your reports, first log on to this other system and run this query," is a non-starter.
Can you schedule automatic refresh?
Scheduling automatic refresh still doesn't solve the problem of running the server-side query. It's also not compatible with DirectQuery mode, if I understand Power BI correctly.