![]() ![]() During the initial Get Data experience, the set of tables selected each define a query that will return a set of data.Import connectionsįor import, when using Get Data in Power BI Desktop to connect to a data source like SQL Server, the behavior of that connection is as follows: These three options for connecting to data: import, DirectQuery, and live connection. A live connection is different in many other regards, so a different term, live connection versus DirectQuery, is used. No data is imported and the underlying data source is always queried to refresh a visual. Using a live connection is similar to DirectQuery. When connecting to SQL Server Analysis Services, you can choose to import the data or use a live connection. SQL Server Analysis Services is a special case. More sources will be DirectQuery enabled in the future, focusing primarily on sources that can be expected to deliver good interactive query performance. ![]() For a summary of the sources that support DirectQuery, see Data Sources supported by DirectQuery. For some, it's also possible to connect using DirectQuery. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |