Converge multiple Source files

In XLPublish you can have multiple Source files feed data Tables into a single Target file if you wish.  This allows you to integrate data from multiple spreadsheets anywhere on your network into a single set of tables in a Target file that Power BI can use as a single Source for a Power BI Report(s).

In order to accomplish this you simply set the Report Name in the Manage dialog as the name of a Target file that might be targeted from multiple sources.  These tables will all be separately defined in the Target table, (which can be combined there using Get and Transform if you wish), and then they will be published to PowerBI every time you Republish with new data from your Source files.

Comment

There is no comment on this post. Be the first one.

Leave a comment

%d bloggers like this: