https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/Publish-to-Power-BI-from-Excel-16/ba-p/5175564 <P>Excel 2016 is out and works better together with Power BI!</P> <P>Microsoft recently announced the availability of <A href="https://blogs.office.com/2015/09/22/thenewoffice/">Office 2016</A>. If you’re already working in Excel, you no longer have to look up your workbook from Power BI. </P><P class="paragraph">We’re excited to announce that you can now effortlessly publish your workbook content to Power BI, directly from Excel 2016!</P> <P class="paragraph">Don’t have Excel 2016 yet? <A href="https://products.office.com/en-us/business/office">Check it out</A>.</P> <P class="paragraph">Once your workbook is published, you can keep working on it in One Drive for Business. Power BI automatically refreshes when you make updates to your workbook!</P> To publish your Excel workbook to Power BI, simply select <STRONG>File &gt; Publish</STRONG>. <DIV></DIV> <P style="text-align: center;">&nbsp;<A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/2627.01.png"><IMG src="https://ip1.i.lithium.com/d5ef8502f0dc255821a320b8b302e0fa115bffb4/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f323632372e30312e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> Excel logs into Power BI with your current account. If you have a Power BI account, you are ready to go. If you don’t have a Power BI account, you can <A href="https://powerbi.microsoft.com?WT.mc_id=Blog_Excel16">sign up for Power BI</A>.<P></P> <P>Excel displays the progress of publishing to Power BI, as shown in the following image. </P><P style="text-align: center;">&nbsp;<A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/1526.02.png"><IMG src="https://ip1.i.lithium.com/e25bcbce33bf8fcf71bdb298f44b7eed0247f15e/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f313532362e30322e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> When complete, it displays a message box that you can select to view the published data and reports from your workbook in Power BI (Power BI loads in your default browser). <P style="text-align: center;"><A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/8004.03.png"><IMG src="https://ip1.i.lithium.com/0c1c7824c431623227cdc3e086d3bfaef593f981/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f383030342e30332e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> You can continue working in the Excel, and updates will automatically occur in Power BI according to the default refresh settings policy in Power BI.<P></P> <P>In Power BI, you can select Reports, then the file name you uploaded (in this case, <A href="https://download.microsoft.com/download/3/C/D/3CDF3BBC-B8F8-4BEC-8223-0FC609B0E7DA/BirthTrends%20Sample.xlsx">BirthTrends Sample</A>) and view the Power View visualization of the Excel report in Power BI. &nbsp;In addition, <A href="https://support.powerbi.com/knowledgebase/articles/424871">supported data</A> is available for you in the Datasets section (In this case, <A href="https://download.microsoft.com/download/3/C/D/3CDF3BBC-B8F8-4BEC-8223-0FC609B0E7DA/BirthTrends%20Sample.xlsx">BirthTrends Sample</A>). </P><P style="text-align: center;">&nbsp;<A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/2703.04.png"><IMG src="https://ip1.i.lithium.com/58fe42413f7eefce6925c81020275aa32a62f8d2/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f323730332e30342e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> <STRONG>Note:</STRONG> Publishing from Excel to Power BI requires the workbook to be saved in OneDrive for Business. If your workbook is not saved to a OneDrive for Business account, publishing to Power BI will guide you through the process of uploading to OneDrive for Business, then publishing to Power BI.<P></P> <P>Try it out today with a self-guided interesting <A href="https://download.microsoft.com/download/3/C/D/3CDF3BBC-B8F8-4BEC-8223-0FC609B0E7DA/BirthTrends%20Sample.xlsx">sample of birth trends data</A>.</P> <P><A href="https://support.office.com/en-us/article/Publish-to-Power-BI-7342b49c-6567-4155-a7ac-acdc14d9ad0f">Click for more details and additional resources</A>. <UL> <LI><A href="https://powerbi.microsoft.com/?WT.mc_id=Blog_Excel16">Try Power BI</A></LI> <LI><A href="https://twitter.com/mspowerbi">Follow @MSPowerBI on Twitter</A></LI> <LI><A href="https://community.powerbi.com?WT.mc_id=Blog_Excel16">Join the conversation at the Power BI Community</A></LI> </UL> </P><DIV style="clear: both;"></DIV><P></P> Thu, 24 Sep 2015 08:00:00 GMT powerbiblogadm 2015-09-24T08:00:00Z https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/Publish-to-Power-BI-from-Excel-16/ba-p/5175564 <P>Excel 2016 is out and works better together with Power BI!</P> <P>Microsoft recently announced the availability of <A href="https://blogs.office.com/2015/09/22/thenewoffice/">Office 2016</A>. If you’re already working in Excel, you no longer have to look up your workbook from Power BI. </P><P class="paragraph">We’re excited to announce that you can now effortlessly publish your workbook content to Power BI, directly from Excel 2016!</P> <P class="paragraph">Don’t have Excel 2016 yet? <A href="https://products.office.com/en-us/business/office">Check it out</A>.</P> <P class="paragraph">Once your workbook is published, you can keep working on it in One Drive for Business. Power BI automatically refreshes when you make updates to your workbook!</P> To publish your Excel workbook to Power BI, simply select <STRONG>File &gt; Publish</STRONG>. <DIV></DIV> <P style="text-align: center;">&nbsp;<A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/2627.01.png"><IMG src="https://ip1.i.lithium.com/d5ef8502f0dc255821a320b8b302e0fa115bffb4/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f323632372e30312e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> Excel logs into Power BI with your current account. If you have a Power BI account, you are ready to go. If you don’t have a Power BI account, you can <A href="https://powerbi.microsoft.com?WT.mc_id=Blog_Excel16">sign up for Power BI</A>.<P></P> <P>Excel displays the progress of publishing to Power BI, as shown in the following image. </P><P style="text-align: center;">&nbsp;<A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/1526.02.png"><IMG src="https://ip1.i.lithium.com/e25bcbce33bf8fcf71bdb298f44b7eed0247f15e/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f313532362e30322e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> When complete, it displays a message box that you can select to view the published data and reports from your workbook in Power BI (Power BI loads in your default browser). <P style="text-align: center;"><A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/8004.03.png"><IMG src="https://ip1.i.lithium.com/0c1c7824c431623227cdc3e086d3bfaef593f981/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f383030342e30332e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> You can continue working in the Excel, and updates will automatically occur in Power BI according to the default refresh settings policy in Power BI.<P></P> <P>In Power BI, you can select Reports, then the file name you uploaded (in this case, <A href="https://download.microsoft.com/download/3/C/D/3CDF3BBC-B8F8-4BEC-8223-0FC609B0E7DA/BirthTrends%20Sample.xlsx">BirthTrends Sample</A>) and view the Power View visualization of the Excel report in Power BI. &nbsp;In addition, <A href="https://support.powerbi.com/knowledgebase/articles/424871">supported data</A> is available for you in the Datasets section (In this case, <A href="https://download.microsoft.com/download/3/C/D/3CDF3BBC-B8F8-4BEC-8223-0FC609B0E7DA/BirthTrends%20Sample.xlsx">BirthTrends Sample</A>). </P><P style="text-align: center;">&nbsp;<A href="https://powerbicdn.azureedge.net/mediahandler/blog/legacymedia/2703.04.png"><IMG src="https://ip1.i.lithium.com/58fe42413f7eefce6925c81020275aa32a62f8d2/68747470733a2f2f706f776572626963646e2e617a757265656467652e6e65742f6d6564696168616e646c65722f626c6f672f6c65676163796d656469612f323730332e30342e706e675f324430305f35353078302e706e67" alt="" border="0" /></A></P> <STRONG>Note:</STRONG> Publishing from Excel to Power BI requires the workbook to be saved in OneDrive for Business. If your workbook is not saved to a OneDrive for Business account, publishing to Power BI will guide you through the process of uploading to OneDrive for Business, then publishing to Power BI.<P></P> <P>Try it out today with a self-guided interesting <A href="https://download.microsoft.com/download/3/C/D/3CDF3BBC-B8F8-4BEC-8223-0FC609B0E7DA/BirthTrends%20Sample.xlsx">sample of birth trends data</A>.</P> <P><A href="https://support.office.com/en-us/article/Publish-to-Power-BI-7342b49c-6567-4155-a7ac-acdc14d9ad0f">Click for more details and additional resources</A>. <UL> <LI><A href="https://powerbi.microsoft.com/?WT.mc_id=Blog_Excel16">Try Power BI</A></LI> <LI><A href="https://twitter.com/mspowerbi">Follow @MSPowerBI on Twitter</A></LI> <LI><A href="https://community.powerbi.com?WT.mc_id=Blog_Excel16">Join the conversation at the Power BI Community</A></LI> </UL> </P><DIV style="clear: both;"></DIV><P></P> Thu, 24 Sep 2015 08:00:00 GMT https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/Publish-to-Power-BI-from-Excel-16/ba-p/5175564 powerbiblogadm 2015-09-24T08:00:00Z