It would be useful if I could "unpivot" (using PowerQuery) the data from Qqube at the source, rather than copy/paste the table from the PowerPivot model and link back to the model as another table. Any ideas on how to accomplish this or where to get started would be much appreciated!
In general we keep the complexities of having to deal with tables and relationships away from the end user. So we have the shells available for PowerPivot - so that people don't have to sit there and figure out how to tie them together. In a data warehouse, there is only one way to put the tables together - and you never tie one subject another, as each one is complete on its own.
You could use PowerQuery, if you new the structure.
There are two ways to do this:
I think the best thing we can do is provide a starter shell for you with the connection string to make this easier. Thank you for bringing this to our attention.
Choose a location