AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Microsoft excel trial201011/7/2023 ![]() In the dialog that pops up after selecting Export data, select the Summarized data card and you will see a new option under the File format dropdown menu. For example, in the Workforce Demographics Report, I want to analyze the Recognized Revenue & Estimated Forecast from SalesForce & Backlog data in Excel. Go to any report in the Power BI service (or ), open More options… on any Power BI visual and select Export data from the menu. How do I export live Power BI Data to Excel? This new export to Excel feature is one of many planned new connected features aimed at improving user productivity by enabling you to self-serve data while keeping your data refreshed in Excel and reducing your reliance on ad-hoc static data requests. And the new open also lets you export more data into Excel from Power BI. The data is refreshable because the generated Excel workbook contains a live connection to Power BI, so you can refresh the data without leaving Excel. ![]() The data loads into the spreadsheet grid so it’s easier to use for most users. This new connected experience enables you to export refreshable data to Excel from a Power BI visual. We have started to roll-out the capability. ![]() Before now, you could only analyze live Power BI data in Excel using PivotTables (with the Analyze in Excel feature) but with this new experience, you’ll be able to use Excel tables to analyze live Power BI data and answer critical business questions with familiar spreadsheet functions. We are introducing a new way for you to explore and analyze live Power BI data in Excel.
0 Comments
Read More
Leave a Reply. |