Forum Discussion

powerbiexpert22's avatar
powerbiexpert22
Impactful Individual
6 months ago

stored procedure as source

can we connect power bi desktop with stored procedure as source to get data ? same question is for report builder for paginated reports    
Need Help
v-sshirivolu's avatar
v-sshirivolu
Community Support
6 months ago

Hi powerbiexpert22 ,

Yes, you can use a stored procedure as a data source in both Power BI Desktop and Paginated Reports. In Power BI Desktop, enter an EXEC statement in the SQL Server connector’s SQL statement box. In Paginated Reports, create a dataset that calls the stored procedure. Note that stored procedures don’t appear as selectable tables in the Navigator and may have limitations when used with DirectQuery.


Microsoft Docs:
• SQL Server database connector (Power Query) -
https://learn.microsoft.com/power-query/connectors/sql-server

• Report paginated data retrieval -
https://learn.microsoft.com/power-bi/guidance/report-paginated-data-retrieval

 

 

v-sshirivolu's avatar
v-sshirivolu
Community Support
6 months ago

Hi powerbiexpert22 ,

I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

  • v-sshirivolu's avatar
    v-sshirivolu
    Community Support
    6 months ago

    Hi powerbiexpert22 ,
    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions