cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
henrikbjerre5 Frequent Visitor
Frequent Visitor

SQL-statements from Excel into Power BI

Hi all

 

I'm new to Power BI and have a question regarding SQL-statements.

 

In our organisation we have an Excel spreadsheet with a Pivot-table, that connects to a database. I'm not an expert in SQL, but I just want the same data that I get into my Excel spreadsheet into Power BI instead, so I can visualize my data.

 

To eamplify, I have attached the connection properties here. It's these data I want in Power BI.

 

Anybody that knows if this is possible? And anybody that can help?

 

Thank you very much in advance.

 

Best regards Henrik

 

Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
sdjensen Senior Member
Senior Member

Re: SQL-statements from Excel into Power BI

Hi,

 

It is possible to get data from a SQL database into Power BI Desktop - if you later want to upload your model to the Power BI Service you will need to setup a gateway to enable data refresh.

 

Perhaps this video can help you: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-2-connect-to-data-sources-in-...

 

Basically what you need to do is:

1. Open Power BI Desktop and select Get Data

2. Select SQL Server as you source

3. Connect to the SQL Server / Database

4. Copy/Paste your select statement from Excel

5. Load the data into your model

/sdjensen

View solution in original post

4 REPLIES 4
sdjensen Senior Member
Senior Member

Re: SQL-statements from Excel into Power BI

Hi,

 

It is possible to get data from a SQL database into Power BI Desktop - if you later want to upload your model to the Power BI Service you will need to setup a gateway to enable data refresh.

 

Perhaps this video can help you: https://powerbi.microsoft.com/en-us/guided-learning/powerbi-learning-1-2-connect-to-data-sources-in-...

 

Basically what you need to do is:

1. Open Power BI Desktop and select Get Data

2. Select SQL Server as you source

3. Connect to the SQL Server / Database

4. Copy/Paste your select statement from Excel

5. Load the data into your model

/sdjensen

View solution in original post

henrikbjerre5 Frequent Visitor
Frequent Visitor

Re: SQL-statements from Excel into Power BI

Can I do it in the online version or is it only the desktop version that allows it?

sdjensen Senior Member
Senior Member

Re: SQL-statements from Excel into Power BI

As far as I know you need to build the model in the Power BI Desktop to get data from an on-premise SQL server.

 

If you ask me I the Power BI Desktop is a much better tool for development.

/sdjensen
henrikbjerre5 Frequent Visitor
Frequent Visitor

Re: SQL-statements from Excel into Power BI

Ok - thank you very much. I'm still waiting for Power BI desktop to be accepted in my organisation. That's why I'm asking.

 

Looking forward to try it.

 

 

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)