If you use a version saving the ODC file, the following warning is displayed as a standard security measure because Excel does not automatically trust the ODC file containing the connection. This technique is also used in following versions if the alternative technique to create a new model in Excel fails for any reson. Versions 1.0.x of this tool was saving the connection string into an ODC file, which was following opened by Excel. Same problem as described in the previous point: the connection changes every time you close and open Power BI Desktop.
You can save the Excel file, but you cannot refresh it.If you refresh or navigate the PivotTable after you close Power BI Desktop, you get a connection error.The connection to Power BI Desktop is lost as soon as you close the Power BI Desktop window.You cannot close the Power BI Desktop window.You will experience several limitations when using the Analyze in Excel for Power BI Desktop external tool: Now you can navigate the Power BI model using an Excel PivotTable. When you have a data model in your PBIX file, by clicking on Analyze in Excel you open a new Excel file connected to the data model hosted in Power BI Desktop.
#Power bi desktop msi install#
By installing Analyze in Excel for Power BI Desktop, you can install a dedicated external tool that creates an Excel file connected to the data in the Power BI Desktop model.
0 kommentar(er)
