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,310 points
1,958 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,550 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
• 16,570 points
82 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
• 42,430 points
45 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
784 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,550 points
54 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,550 points
1,195 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
• 31,840 points
102 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
107 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,550 points
338 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,550 points
58 views