Forum Discussion
Helper IPower BI Vertica sql query
Hello! Can i put sql query when i connect to Vertica from Power BI? I mean when i add ms sql server such as source, i can write sql query, maybe it's possible to vertica.
Hi vaalyushin ,
Here's a step by step guide for your reqirement.
https://www.vertica.com/kb/Integration-with-Microsoft-Power-BI-Connection-Guide/Content/Partner/Integration-with-Microsoft-Power-BI-Connection-Guide.htm#:~:text=Power%20BI%20allows%20Import%20as,leverage%20the%20speed%20of%20Vertica.&text=By%20design%2C%20the%20Vertica%20named,not%20allow%20writing%20SQL%20statements.
1 Reply
- truptis
Community Champion
Hi vaalyushin ,
Here's a step by step guide for your reqirement.
https://www.vertica.com/kb/Integration-with-Microsoft-Power-BI-Connection-Guide/Content/Partner/Integration-with-Microsoft-Power-BI-Connection-Guide.htm#:~:text=Power%20BI%20allows%20Import%20as,leverage%20the%20speed%20of%20Vertica.&text=By%20design%2C%20the%20Vertica%20named,not%20allow%20writing%20SQL%20statements.