![]() If you need to make changes that will be saved, select Edit from the upper-right corner to open it for editing in Excel Online or Excel. If you sort, filter, or change values in Power BI, those changes cannot be saved or pinned. Open the workbook in Power BI by selecting the workbook name.Ĭhanges you make to the workbook in Power BI are not saved and do not affect the original workbook on OneDrive for Business. The icon indicates this is an Excel workbook. In Power BI, the workbook is added to your workspace. Select the file and choose Connect > Connect. Upload your workbook to your OneDrive for Business.įrom Power BI, connect to that workbook by selecting Get Data > Files > OneDrive - Business and navigating to the location where you saved the Excel file. Any changes you make are saved to the workbook on OneDrive. ![]() But if you need to make some changes, you can select the pencil icon from the Workbooks tab of your workspace, and then choose to edit your workbook in Excel Online or open it in Excel on your computer. You can’t edit your workbook in Power BI. But, unlike Excel Online, you’ll have some great features to help you pin elements from your worksheets right to your dashboards. ![]() When you choose Connect, your workbook will appear in Power BI just like it would in Excel Online. Connect your Excel workbook from OneDrive for Business to Power BI This video might use earlier versions of Power BI Desktop or the Power BI service.
0 Comments
Leave a Reply. |