We are certain that you’ll get value out of it IMMEDIATELY ! While the saying is “Excel and Power BI “Better” Together” …
We say “Excel and XLPublish and Power BI “Best” Together” 🙂 But the big story is Analysis Services, Business Intelligence, Cloud, Excel, Office Automation, OLAP, Power BI, Power BI Desktop, Power Query, Power Pivot, Process Automation, Self-Service BI, Spreadsheets, the Cloud, XLPublish, is already a complete and mature piece of tech at this point, we have added one new feature that you might find useful, Multi-Workspace Publishing With the introduction of App Workspaces in Power BI (a great way to organize your various “audiences” for power BI Dashboards/Reports) we have decided to add the ability to Publish will have its own synchronized version of the Single Latest Dataset published from that single Excel Source file. Save Msg Box "PBI Update Complete", vb Information vb OKOnly, "PBI Update" Exit Sub PBIErr: Msg Box Err.
All you need to do is string a list of your Workspace targets separated by commas in the Workspaces dialog : Thanks to App Workspaces and Just a note that I will be in New York on Monday and Tuesday Dec 4 & 5 exhibiting and presenting at: Modeloff GTC New York I will be showing the latest iteration of the XLPublish add-in on exhibit with several new and exciting capabilities (including our new CUBE feature). Name) - 5) & ".xlsx", File Format:=xl Open XMLWorkbook Target. Description & " - Please report this error to your Adminstrator immediately.", vb Critical, "PBI Update Error" Application.
I know that this is anathema to sooooo many in the IT industry, and even, if I might be so bold, in Microsoft itself (which has always been hard for me to accept). But I personally see the potential of Microsoft’s Power BI (both in the tech as well as the cost and the sizeable potential market). but with NO guarantee and a history of failures over many decades now. BUT at the same time the existing models are built by people who work in their companies and understand not just the tech but also the business. Frankly, to convert EVERY company away from spreadsheets to data warehousing would require an army of capable database/BI/Analysts worldwide that just cannot be grown in any future I can envision. All the talk about Self-Service BI for the last few years caught my eye with the release of Denali in 2011 and Power BI for Office 365 in 2013. (Note …While this post is about Power BI I believe that it all probably applies to competitive products currently on the market).