Stored procedure call with date parameter from vertica datavbase

[sahubibhuti45]

Hi Beautiful Minds,

I just have checked the compatibility with the microsoft database's stored procedures passing to the power bi desktop and then call them and use in front end.

Similar exercise can we call a stored procedure from Vertica database to the power bi desktop and call the stored procedure?

Thanks

[v-huijiey-msft · Accepted solution]

Hi @sahubibhuti45 ,

Hope everything is going well.

Please follow these step:

1. Install Vertica is ODBC driver. If not, you can download it from the Vertica website.

2. - In Power BI Desktop, go to Get Data > More > Other > ODBC.

     - Select a DSN for the Vertica database or provide a connection string.

     - Select OK to establish the connection.

3. - Once connected, you can execute the stored procedure by selecting it from the Navigator pane or by using the Advanced options to input a custom SQL query to call the stored procedure.

If your stored procedure requires a date parameter, your query might look like "CALL your_stored_procedure_name('2023-01-01');".

For detailed guidance on connecting to data sources using ODBC in Power BI, see the following documentation:

Power Query ODBC connector - Power Query | Microsoft Learn

Vertica Integration with Microsoft Power BI: Connection Guide

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[sahubibhuti45 · Accepted solution]

thanks, this helped

[v-huijiey-msft · Accepted solution]

Hi @sahubibhuti45 ,

Hope everything is going well.

Please follow these step:

1. Install Vertica is ODBC driver. If not, you can download it from the Vertica website.

2. - In Power BI Desktop, go to Get Data > More > Other > ODBC.

     - Select a DSN for the Vertica database or provide a connection string.

     - Select OK to establish the connection.

3. - Once connected, you can execute the stored procedure by selecting it from the Navigator pane or by using the Advanced options to input a custom SQL query to call the stored procedure.

If your stored procedure requires a date parameter, your query might look like "CALL your_stored_procedure_name('2023-01-01');".

For detailed guidance on connecting to data sources using ODBC in Power BI, see the following documentation:

Power Query ODBC connector - Power Query | Microsoft Learn

Vertica Integration with Microsoft Power BI: Connection Guide

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!