Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
sahubibhuti45
Frequent Visitor

Stored procedure call with date parameter from vertica datavbase

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

2 ACCEPTED SOLUTIONS
v-huijiey-msft
Community Support
Community Support

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.

 

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

      

vhuijieymsft_0-1708578389195.png

 

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

 

     - Select OK to establish the connection.

 

  1. - 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!

View solution in original post

sahubibhuti45
Frequent Visitor

thanks, this helped

View solution in original post

2 REPLIES 2
sahubibhuti45
Frequent Visitor

thanks, this helped

v-huijiey-msft
Community Support
Community Support

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.

 

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

      

vhuijieymsft_0-1708578389195.png

 

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

 

     - Select OK to establish the connection.

 

  1. - 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!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.