Forum Discussion
Adding query hints in M (Vertica)
Hi, Is there some function or property in M to add query hints? We are using Vertica as backend data warehouse and OleDB driver to access it from Power BI. When running queries in a SQL tool...
Understanding your problem I have come to a solution and it is to connect through ODBC, creating the dns and there if you can place a query, this tutorial will summarize your doubt in a better way: https://www.vertica.com/kb/Integration-with-Microsoft-Power-BI-Connection-Guide/Content/Partner/Integration-with-Microsoft-Power-BI-Connection-Guide.htm