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 how you are connecting to your Vertica data source
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
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.