So I’ve connected to a PowerBI template app via App Source and installed it in PowerBI service and would like to model some additional data on top of it.
I can see how I can:
Connect from PowerBI Desktop and access the data from that template app to create additional reports. However when I do this, I can no longer edit the dataset or add additional queries to merge the dataset (see sample .pbix file)test mergin template apps with datasets.pbix (6.3 KB)
Create additional reports from the template app’s dataset from PowerBI Service. However again there is no option to further extend the data model with additional tables
Create an additional dataset and create a second report off of that new dataset and create a dashboard that shows the template app data next to the new data. However this doesn’t allow me to easily combine filters and I’d have to add the same filter on both pinned report tiles or live pages to be able to compare the same data.
However, I would like to take this dataset from the template app and model it with some additional data that I have on a local spreadsheet or cloud spreadsheet (e.g. google sheets). E.g. Let’s say the template app dataset has a list of locations and the address for each and I’d like to link a new table from a spreadsheet that contains a list of sales by location in a many-to-one sort of relationship. Is this possible to do in PowerBI Service or desktop? It seems I can hack some of this using excel spreadsheets instead and create pivot tables off of the data but that seems more fragile than using the modelling tools in PowerBI directly. I had a brief look at dataflows too but those could not connect to the dataset from the template app.