Archives of #Power Pivot

XLPublish Demo Videos 1 to 3

Here are 3 videos with increasing lengths and detail … The first (Using XLPublish To Publish to Power BI) is a quick (4 min) video showing how you would use an XLPublish configured Excel file on an ongoing basis to refresh the data in your Power BI Reports. The second (The Settings¬†Inside An XLPublish Solution) […]

XLPublish Is Here !!

Today Personal Logic Associates Inc. is proud to ship the XLPublish – our new Add-in for Excel that makes publishing your Excel data in Power BI Easy, Reliable and Repeatable. With XLPublish you can make your current Excel Ranges, Tables, Pivot Tables and Charts on-going sources of Power BI Datasets. Without installing a data gateway! […]

Advanced Target Folder Options

There are 4 places that you can use as Target Folders in XLPublish… 1. The Source File’s folder This is the default and most common place to place your Target file for many obvious reasons, most notably that the files stay together in your own personal Workspace. This of course becomes a problem (or a […]