Forum Discussion
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-power-bi-desktop
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
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-power-bi-desktop
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
Can I do it in the online version or is it only the desktop version that allows it?
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.
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.
