Forum Discussion
Create a query to select data from a table
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
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? 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. Thanks