Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

parry2k's avatar
parry2k
Super User
6 years ago

Anonymous how you are connecting to your Vertica data source

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous got it, you are using native connector, why not you create a view in your vertica database and use that to feed to power bi

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yeah, I'm exploring adding this query as a view in the database, but since I'm not the database admin/owner, I'm dependent on others for that. Hopefully it'll pan out, but it might not.

       

      Is there really no way to write a SQL query within Power BI? This seems like a rather fundamental request.