Create a query to select data from a table

Question

How do I write a query to select data from a SQL table? I mean an SQL statement to get specific data from te table.&nbsp;Thanks

greg_deckler · Answer

When you connect to SQL Server, expand the "Advanced options" as show in the screen shot below and then just paste in your SQL code.

markzolotoy · Answer

That is when I import data. But about&nbsp;pulling data at real time?&nbsp;

greg_deckler · Answer

Should be essentially the same process. See the Advanced options here for DirectQuery from Azure SQL Database:

https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/

Advanced options provides a Custom filters section, and supplies an example of a SELECT statement.

anonymous · Answer

Hi Markzolotoy, Do you connect to the table from on-premises SQL Server database in Power BI Desktop and want to pull data at real time? If that is the case, there is no such feature in Power BI Desktop. However we can manually change query to select different data using Advanced Editor of Query Editor, for more details about Advanced Editor, please review the this article: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-query-overview/ . Moreover, we can utilize the Schedule Refresh feature to refresh dataset created from Power BI Desktop files imported from a local drive where Get Data/Query Editor is used to connect to and load data from on-premises SQL Server database. For more details, please review the following articles. https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-desktop-file-local-drive/ https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/#understanding-data-refresh Thanks, Lydia Zhang

condor5635 · Answer

so if i wanted to select data from a view in a DB2 database, i cannot create a datasource of that nature is that correct?&nbsp; I have successfully created the data source for said DB2 connection and am able to pull all the data from the view but i would like to limit it further with SQL.&nbsp; Thanks

Forum Discussion

Create a query to select data from a table

5 Replies

Related content

Power Query List.Skip, Select

Power Query: Select...Case...End Select

Automate creating new queries ...

Can i use a measure selected in a slicer (created with field parameters) to create a rank?

Create custom query in Desktop