Using Data Import

The most commonly used method to interact with static data sets is the PowerBI Data Import function. Use Data Import mode to save a copy of the data in your report. As you make changes to your report, Power BI executes the underlying queries to the local cache, independent of the connector.

To synchronize your report with any changes in the remote data, use the Home menu's Refresh function.

Advanced Options

The Advanced Options field enables users to provide a SQL statement that specifies what data to return. To configure this option, expand the Advanced Options area, then type or paste in the desired SQL statement into the SQL statement field.

For information on how to limit the number of returned records (as long as there is no aggregation), see DirectQueryLimit.

Note: SQL statements are not supported in DirectQuery mode.

You can use the following types of SQL statements:

• SELECT Statements extract data from a database. For example:
  

  SELECT * FROM Account

• EXECUTE Statements call procedures that are stored in a database. For example:
  

  EXECUTE my_proc @second = 2, @first = 1, @third = 3;