LIVE DESKTOP OFFLINE
LIVE DESKTOP WINDOWS

Your current Windows credentials are used to connect to the Analysis Services server. Question: If I created a live connection, is it secure?ДЄnswer: Yes. Question: If I created a live connection, can I edit the model or query in Power BI Desktop?ДЄnswer: You can create report level measures in the Power BI Desktop, but all other query and modeling features are disabled when exploring live data. If youвЂ™ve already imported data or connected to a different data source in a Power BI Desktop file, you need to create a new file to explore live. You can't explore live data and connect to another type of data source in the same file. Question: If I created a live connection, can I connect to another data source in the same Power BI Desktop file?ДЄnswer: No. However, if you publish your Power BI Desktop file to your Power BI site, a gateway is required. When connecting live to a tabular model from Power BI Desktop, a gateway isn't required because the Power BI Desktop and the Analysis Services server youвЂ™re connecting to are both running on-premises in your organization. Question: WhatвЂ™s the difference between connecting live to a tabular model from the Power BI service versus connecting live from Power BI Desktop?ДЄnswer: When connecting live to a tabular model from your site in the Power BI service to an Analysis Services database on-premises in your organization, an on-premises data gateway is required to secure communications between them. If you choose to select items and get data, you import tabular model data directly into your Power BI Desktop file, so no gateway is necessary. Be sure to talk to your Analysis Services server administrator before installing a data gateway. On the other hand, if you do intend on publishing to your Power BI site, a data gateway is necessary to ensure secure communication between the Power BI service and your on-premises Analysis Services server.

If you use Power BI Desktop to connect live to a tabular model, but have no intention to publish to your Power BI site, you don't need a gateway. Question: Do I need an on-premises data gateway?ДЄnswer: It depends. When youвЂ™re ready, select Load to import the data into Power BI Desktop. To shape your data before loading, select Transform data to open Power Query Editor. If you chose to select items and get data, select a tabular model or perspective, and then select a particular table or column to load. If youвЂ™re connecting live, select a tabular model or perspective. This step in the Navigator window depends on the connection mode you selected: In the SQL Server Analysis Services database window, enter the Server name, choose a connection mode, and then select OK. Select SQL Server Analysis Services database, and then select Connect. In Power BI Desktop, on the Home ribbon, select Get Data > More > Database.

LIVE DESKTOP OFFLINE

Because no live connection between Power BI Desktop and the tabular model is maintained, you can then explore your Power BI Desktop model offline or publish to your Power BI site. Use Power BI DesktopвЂ™s Power Query Editor to further shape what you want and its modeling features to further model the data. Select items and import into Power BI Desktop: When you connect with this option, you can select items like tables, columns, and measures in your tabular model or perspective and load them into a Power BI Desktop model.

To learn more, see On-premises data gateway. When you publish a Power BI Desktop file with a live connection to a tabular model to your Power BI site, an on-premises data gateway must be installed and configured by an administrator. When youвЂ™ve created dynamic reports in Power BI Desktop, you can share them by publishing to your Power BI site. Items that appear in Power BI Desktop depend on your permissions for the tabular model youвЂ™re connected to. Keep in mind that tabular models are highly secure. YouвЂ™re always looking at the latest data that is available in the tabular model, either from the last processing time, or from DirectQuery tables available in the tabular model. Each time you interact with a visualization, Power BI Desktop queries the tabular model and calculates the results you see. When connecting live, no data from the tabular model is imported into Power BI Desktop. You can use Power BI DesktopвЂ™s advanced visualization and report tools to explore your tabular model in new, highly interactive ways. With Power BI Desktop, there are two ways you can connect to and get data from your SQL Server Analysis Services tabular models: Explore by using a live connection or select items and import them into Power BI Desktop.Д®xplore by using a live connection: When using a live connection, items in your tabular model or perspective, like tables, columns, and measures appear in your Power BI Desktop Fields pane list.

Live desktop