Power BI on Premises RS - Vertica connection String for ODBC (Direct Query) ???
Hi Experts, We have scenario here where in we need to integrate Vertica DS with Power BI on-prem reporting server rather Power BI Service, per document direct query requires connection string on the on-prem RS, we have installed RS and upto report upload all good which built via BI Desktop. Accessing reports failing as the connection string not set. Again per document Vertica is not mentioned for direct query, posting here to know if anything tested and path forward for the same. Let me know if only option is Power BI service for Vertica Direct query ????? Thanks a lot !!!
Issues with Vertica Scheduled refresh
Greetings, I connected one of my dashboards to a Vertica DB using the import connection mode. Didn't had any problems with that, so I published the dashboard and when I tried to set a scheduled refreshed, this error appeared: I thought it had something to do with the ODBC connector so I installed the Vertica driver and set it up using this guide: https://www.vertica.com/kb/Integration-with-Microsoft-Power-BI-Connection-Guide/Content/Partner/Integration-with-Microsoft-Power-BI-Connection-Guide.htm But havent got any luck with it. Does anyone has an idea of why this could be happening? Thanks in advance!
