Forum Discussion
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
5 Replies
I dont know about report builder but stored procedure as a data source should be possible if it returns a table and using import mode. Pleaes refer to this thread https://community.fabric.microsoft.com/t5/Desktop/How-to-use-a-SQL-Server-Stored-Proc-with-no-parameters-as-a/td-p/1182437
Yes, it is possible on both.
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-retrievalHi 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.
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
