{"id":3519,"date":"2020-10-30T21:55:55","date_gmt":"2020-10-30T20:55:55","guid":{"rendered":"https:\/\/thebipower.fr\/?p=3519"},"modified":"2021-04-12T14:30:22","modified_gmt":"2021-04-12T12:30:22","slug":"easily-export-to-excel-with-power-bi-sidetools","status":"publish","type":"post","link":"https:\/\/thebipower.fr\/index.php\/2020\/10\/30\/easily-export-to-excel-with-power-bi-sidetools\/","title":{"rendered":"Easily export to Excel with Power BI Sidetools"},"content":{"rendered":"\n<p>While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don&#8217;t want these users to refresh the data.<\/p>\n\n\n\n<p>Coming with version 1.1.0, Power BI Sidetools exports your data into Excel with only one click. Then you can setup pivot tables, add theme &amp; graphics, macros and do whatever you want. You can even generate a paginated report. Next time you will open this file from Power BI Sidetools, it will be refreshed and you will keep all the setup you did previously. Super quick and super efficient in few steps.<\/p>\n\n\n\n<p>Have a look at this blog post about Power BI Sidetools and download it in the &#8216;Setup&#8217; chapter : <a rel=\"noreferrer noopener\" href=\"https:\/\/thebipower.fr\/index.php\/power-bi-sidetools\/\" target=\"_blank\" class=\"rank-math-link\">https:\/\/thebipower.fr\/index.php\/power-bi-sidetools\/<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Create an Excel file connected to the pbix file<\/h2>\n\n\n\n<p>Open Power BI Sidetools from your Power BI desktop report using the &#8216;External tools&#8217; tab. Power BI Sidetools will be connected to your report.<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 31%\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"489\" height=\"251\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-2.png\" alt=\"Export to Excel\" class=\"wp-image-3537 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-2.png 489w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-2-300x154.png 300w\" sizes=\"(max-width: 489px) 100vw, 489px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>In Power BI Sidetools, under the &#8216;Files&#8217; menu, click on &#8216;Export to Excel\/Create connected Excel file&#8217;. <\/p>\n<\/div><\/div>\n\n\n\n<p>Then, an Excel file will be created with a connection to the Power BI desktop model. To be precise, it is a connection to the local instance of Analysis Services created by Power BI desktop. Until Power BI desktop is closed, the connection will not need Power BI Sidetools.<\/p>\n\n\n\n<p>You can setup the pivot table automatically created. Please notice you cannot use implicit measures in the pivot table. That means you cannot make a sum of a numeric column. You will have to create a measure calculating the sum. That&#8217;s an explicit measure and a very good practice.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Force the connection to be refreshed when the file is opened<\/h2>\n\n\n\n<p>If you want fresh data when you will open the Excel file next time, you will need to click on the refresh button in the &#8216;Data&#8217; tab of the ribbon. This can be done automatically changing the settings of the connection in Excel :<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 33%\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"338\" height=\"298\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-3.png\" alt=\"Export to Excel\" class=\"wp-image-3541 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-3.png 338w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-3-300x264.png 300w\" sizes=\"(max-width: 338px) 100vw, 338px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<ul id=\"block-f7444e6d-2ed6-4492-a761-6b5336ef50de\"><li>Open the &#8216;Data&#8217; tab of the ribbon<\/li><li>Click on &#8216;Connexions&#8217; button<\/li><li>Click on &#8216;Properties&#8217; button<\/li><li>Check &#8216;Refresh data when opening the file&#8217;<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Format and document data in Excel sheets<\/h2>\n\n\n\n<p>You are totally free to setup the Excel file like :<\/p>\n\n\n\n<ul><li>click inside the pivot table and select a theme in the &#8216;Creation&#8217; tab of &#8216;Pivot table tools&#8217;<\/li><li>click inside the pivot table and add graphics or segment in the &#8216;Insert&#8217; tab<\/li><li>add macros ad save as .xlsm<\/li><li>add a Power View tab<\/li><li>add comments<\/li><li>lock sheets to prevent modifications<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Eventually print or save a paginated report as a PDF<\/h2>\n\n\n\n<p>You may setup the print settings and export as a PDF. You will get a paginated report.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Eventually convert the pivot table into a flat table<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Solution 1<\/h3>\n\n\n\n<p>After you set up the pivot table like explained above :<\/p>\n\n\n\n<ul><li>Display the grand total of the pivot table<\/li><li>Double click on the grand total cell. A new sheet is created with a table (not a pivot table)<\/li><li>Right click on any cell of the table and select &#8216;Table\/Edit query&#8217;<\/li><li>Feel free to modify the command text with any DAX formula. Ex : EVALUATE &#8216;<em>Your table name<\/em>&#8216;<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Solution 2<\/h3>\n\n\n\n<ul><li>Duplicate the sheet containing the pivot table and display the new sheet<\/li><li>Be sure all the data you need is displayed<\/li><li>Select a cell within the pivot table<\/li><li>In the ribbon, select the &#8216;Creation&#8217; tab under &#8216;Pivot table tools&#8217;<\/li><li>Remove totals and subtotals<\/li><li>Click on &#8216;Report layout&#8217; button, then select &#8216;Show in tabular form&#8217; and &#8216;Repeat all item labels&#8217;<\/li><li>Right click a cell containing + or &#8211; icon, then select &#8216;Expand\/collapse&#8217; \/ &#8216;Expand entire field&#8217; <\/li><li>In the ribbon, select the &#8216;Analyze&#8217; tab under &#8216;Pivot table tools&#8217;<\/li><li>Click on &#8216;OLAP tools&#8217; button, then select &#8216;Convert to formulas&#8217;<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Save the Excel file<\/h2>\n\n\n\n<p>Save the Excel file in the &#8216;Exports&#8217; folder located in &#8216;C:\\Users\\<em>your username<\/em>\\Documents\\Power BI Sidetools\\<em>your report.pbix<\/em>\\5. = EXPORTS =======================&#8217;. The name of exports folder might be changed in the settings.<br>Next time you will go to &#8216;Export to Excel&#8217; menu, you will find your Excel file.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Share the Excel file<\/h2>\n\n\n\n<p>Do not hesitate to share the Excel file on the network. Users will not be able to refresh data but it will still be dynamic. <br>Please consider the pivot table can be modified allowing users to view any data so locking modifications might be a good option.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reuse the Excel file in the future with just one click<\/h2>\n\n\n\n<p>Once your Excel report is setup, you may open it at any time but it will content the last refreshed data. <\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 32%\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"248\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-4.png\" alt=\"Export to Excel\" class=\"wp-image-3543 size-full\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-4.png 485w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/image-4-300x153.png 300w\" sizes=\"(max-width: 485px) 100vw, 485px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>If you want to refresh it, open the Excel report with Power BI Sidetools.<\/p>\n<\/div><\/div>\n\n\n\n<p>Create as many Excel reports as you need and store them in the Exports folder. They will appear right near the &#8216;Export to Excel&#8217; menu item.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Good practices<\/h2>\n\n\n\n<p>As a good practice, I suggest you create a calculated table in Power BI desktop with the appropriate filters. You will just need to display this table within Excel&#8217;s pivot table.<\/p>\n\n\n\n<p>Hiding tables and columns within Power BI desktop will also help to setup the Excel file. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">References about Export to Excel<\/h2>\n\n\n\n<p>In the service, there is a possibility to &#8220;Analyze in Excel&#8221; which creates an Excel file connected to the service :<br>   <a href=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-analyze-in-excel\" target=\"_blank\" aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" class=\"rank-math-link\">https:\/\/docs.microsoft.com\/en-us\/power-bi\/collaborate-share\/service-analyze-in-excel<\/a><\/p>\n\n\n\n<p>Marco Russo from SQLBI developped an external tool to create an Excel file connected to the desktop. I reused a part of Marco&#8217;s code to create the connection between Power BI desktop and the Excel file. Thank you Marco ! <br>   <a aria-label=\" (opens in a new tab)\" rel=\"noreferrer noopener\" href=\"https:\/\/www.sqlbi.com\/tools\/analyze-in-excel-for-power-bi-desktop\/\" target=\"_blank\" class=\"rank-math-link\">https:\/\/www.sqlbi.com\/tools\/analyze-in-excel-for-power-bi-desktop\/<\/a><\/p>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\t\t\t<div class=\"wp-block-uagb-post-carousel uagb-post-grid  uagb-post__image-position-top uagb-post__image-enabled uagb-block-0218724d     uagb-post__arrow-outside uagb-slick-carousel uagb-post__items uagb-post__columns-3 is-carousel uagb-post__columns-tablet-2 uagb-post__columns-mobile-1\" data-total=\"1\" style=\"\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"674\" height=\"193\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png\" class=\"attachment-large size-large\" alt=\"Custom analyser\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser.png 674w, https:\/\/thebipower.fr\/wp-content\/uploads\/2022\/10\/Custom-analyser-300x86.png 300w\" sizes=\"(max-width: 674px) 100vw, 674px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Custom analyser<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>With &#8216;Custom analyser&#8217; feature, Power BI Sidetools users can use external tools built by the&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2022\/10\/22\/custom-analyser\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"592\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png\" class=\"attachment-large size-large\" alt=\"DAX debugger\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1024x592.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-300x173.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-768x444.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger-1320x763.png 1320w, https:\/\/thebipower.fr\/wp-content\/uploads\/2021\/04\/DAX-debugger.png 1452w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">DAX debugger in Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>DAX debugger is meant to help Power BI report developers displaying sample data from a&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2021\/04\/05\/dax-debugger\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"817\" height=\"495\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager.png\" class=\"attachment-large size-large\" alt=\"External tools manager\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager.png 817w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager-300x182.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/12\/External-tools-manager-768x465.png 768w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Manage your external tools easily with Power BI Sidetools<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Since the Power BI team allowed to launch external tools from the Power BI desktop&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/12\/01\/manage-your-external-tools\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"209\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-1024x209.png\" class=\"attachment-large size-large\" alt=\"search\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-1024x209.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-300x61.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6-768x156.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-6.png 1286w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Powerful text and file search in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>As Power BI Sidetools creates files from your report, you are able to search through&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/03\/powerful-text-and-file-search\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<article class=\"uagb-post__inner-wrap\">\t\t\t\t\t\t\t\t<div class='uagb-post__image'>\n\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"294\" src=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-1024x294.png\" class=\"attachment-large size-large\" alt=\"Visual Studio Code\" srcset=\"https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-1024x294.png 1024w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-300x86.png 300w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5-768x220.png 768w, https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/09\/image-5.png 1269w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<h4 class=\"uagb-post__title uagb-post__text\">\n\t\t\t\t<a href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Compare DAX and M formulas in Visual Studio Code<\/a>\n\t\t\t<\/h4>\n\t\t\t\t\t\t<div class='uagb-post__text uagb-post-grid-byline'>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class='uagb-post__text uagb-post__excerpt'>\n\t\t\t\t\t<p>Compare DAX and M formulas in Visual Studio Code is really easy with the help&#8230;\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"uagb-post__text uagb-post__cta wp-block-button\">\n\t\t\t\t<a class=\"wp-block-button__link uagb-text-link\" href=\"https:\/\/thebipower.fr\/index.php\/2020\/09\/02\/compare-dax-and-m-formulas-in-visual-studio-code\/\" target=\"_self\" rel=\"bookmark noopener noreferrer\">Read More<\/a>\n\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/article>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t","protected":false},"excerpt":{"rendered":"<p>While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don&#8217;t want these users to refresh the data. Coming with version 1.1.0, Power BI Sidetools exports your data into Excel with only one click. Then you can setup pivot tables, add theme&#8230;<\/p>\n","protected":false},"author":2,"featured_media":3532,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_uag_custom_page_level_css":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[8,2,75],"tags":[20,21,24,73],"uagb_featured_image_src":{"full":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel.png",1854,750,false],"thumbnail":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-150x150.png",150,150,true],"medium":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-300x121.png",300,121,true],"medium_large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-768x311.png",768,311,true],"large":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1024x414.png",1024,414,true],"1536x1536":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1536x621.png",1536,621,true],"2048x2048":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel.png",1854,750,false],"mailpoet_newsletter_max":["https:\/\/thebipower.fr\/wp-content\/uploads\/2020\/10\/Export-to-Excel-1320x534.png",1320,534,true]},"uagb_author_info":{"display_name":"Didier TERRIEN","author_link":"https:\/\/thebipower.fr\/index.php\/author\/masterpower\/"},"uagb_comment_info":6,"uagb_excerpt":"While working in Power BI desktop, we often need to export to Excel some data sharing with customers or colleagues. Once shared, we don&#8217;t want these users to refresh the data. Coming with version 1.1.0, Power BI Sidetools exports your data into Excel with only one click. Then you can setup pivot tables, add theme...","_links":{"self":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/3519"}],"collection":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/comments?post=3519"}],"version-history":[{"count":28,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/3519\/revisions"}],"predecessor-version":[{"id":3916,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/posts\/3519\/revisions\/3916"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media\/3532"}],"wp:attachment":[{"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/media?parent=3519"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/categories?post=3519"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thebipower.fr\/index.php\/wp-json\/wp\/v2\/tags?post=3519"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}