Power BI Using SQL Server stored procedures

0 votes
So, I want to use the SQL Server table to generate reports and I have some already made stored procedures that I would like to use to generate reports from. But I can't really find a way to do so.

Can anyone help me?

Thanks!
Dec 14, 2018 in Power BI by Shubham
• 12,150 points
640 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes

NOTE: The following works for the "Import Query" option, only.

Execution of Stored Procedure:

1. Right click on your SP, in SQL Server and select Execute. A new query window opens up, as your code is executed, which was responsible for execution. Copy the Query.

2. In Power BI Query Editor, select New Source-->SQL Server. After giving the server and database, in the same window click on Advanced Options, paste the query in the SQL Statement that opened up. Check Navigate using full hierarchy and click on OK.

3. Now, you should be able to see data for the parameters you passed.

When you've applied these changes, you will see the dataset for this in Power BI Desktop from where you can create reports.

Cheers.

answered Dec 14, 2018 by Upasana
• 7,560 points

Related Questions In Power BI

0 votes
1 answer
0 votes
1 answer

Is it possible to manage limits while using dedicated capacity power bi embedded app service?

These limits are not related to using ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 14,080 points
30 views
0 votes
1 answer

Power BI Reporting Server - Portal Administrator Functionality

I think you need to link it ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 35,750 points
16 views
0 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

answered Oct 3, 2018 in Power BI by Nilesh
• 6,900 points
318 views
0 votes
1 answer

Calculate Time Intersection to Correlate Sequences of Independent Events

I think this solution requires a CROSS JOIN implementation. ...READ MORE

answered Oct 26, 2018 in Power BI by Upasana
• 7,560 points
31 views
0 votes
1 answer

Time Series Chart in Power BI

Your Date format should be handled by ...READ MORE

answered Nov 26, 2018 in Power BI by Upasana
• 7,560 points
444 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

answered Mar 22 in Power BI by CHERUKURI
• 13,860 points
29 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,040 points
48 views
0 votes
1 answer

Error:connecting to Azure SSAS server in Power-BI through Import mode

If I understand correctly, you're connecting to ...READ MORE

answered Nov 9, 2018 in Power BI by Upasana
• 7,560 points
119 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 7,560 points
30 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.