1. Data Import / Export
I'm working on a software which produces and consumes OData / Atom Files.
My goal is to use PowerPivot as a endpoint for data browsing and analysing. So, my software exports as REST Urls some tables in Atom Format and the list of these tables are exported in Atom Service format...
All work perfectly : I manage to import and browse all tables in powerpivot.
Now, I work on next step.
In my software, my tables are linked. One column can be ID for another table and I know this relationships.
In Atom format, I found atom:link and href attribute for each property. So I tried to link tableA.column18 to tableB.column1 by pointing the href attribute on the tableB atom rest URL.
Powerpivot accepts these changes but nothing change in gui behavior.
What I would like is to be able to click in tab TableA on column18 to access to second tab tableB on the right line by using table relationships featured by Powerpivot. Is it possible ?
If tableB was not yet loaded, it would load it dynamically.