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
• 13,290 points
1,421 views

1 answer to this question.

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
• 8,530 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,070 points
63 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
• 40,440 points
34 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,880 points
599 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
• 8,530 points
42 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
• 8,530 points
921 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
• 25,660 points
65 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,060 points
77 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
• 8,530 points
241 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
• 8,530 points
48 views