Forum Discussion
Connection between Dataset and Reports
I created the template workspace like this:
- create new workspace, check template workspace box
- click upload, and upload Dataset and all reports necessary
I just did it again for some screenshots:
1. Template workspace with dataset and one report, uploaded from my local machine. I didn't upload any Dashboard by the way, I get that for free.
2. "Funny" lineage, thanks for pointing out this view, but this one Report should point to this one Dataset. I can't see how to change this here, and how the connections are right now (the Dataset in every workspace has the same name, because I'm publishing the same file locally over and over).
Then I tried to create an App:
3. It doesn't recognize the Dataset, that really has parameters and is a Data source.
The Golden Dataset is really interesting, but I can't use that here unfortunately. In my case, the Dataset is exactly the same for all of our customers, but the only thing that's different is the data itself that is ingested.
What I will check is what happens if I (re)-publish a Dataset to a workspace without changing the parameter (pointing to the Azure Application Insights location, where the data comes from) locally. Maybe it will be overwritten automatically with the parameter allready set in the workspace (although some workspace are connected with Organizational account type credentials, and others with Basic ...). Same for the Reports, I'll check the lineage view after republishing, but I'm afraid this also won't work ...
Hi RubenT,
unfortunately I do not have answer to your challenge. But if i understand correctly, what you trying to do is to create an App in Appsource, and your client will install the app on their power bi tenant to view report/data that is relevant to them ( based on parameters ). If that is true, it will be the client that will input the right parameter so their report connect to the right data source when they install the app.
You may have seen this documentation, but i will put it here anyway.
Hi Tutu_in_YYC,
We are investigating both routes. I indeed would like it to work as you describe above, and I understand that the clients will input the right parameter. However, we want to make it a paid app and I can't find any other paid Power BI Apps, and neither any documentation on this.
So the other route would therefore be to publish apps for customers in our own tenant in separate workspaces per customer, and share access with them. But then we could end up having up to 60 workspaces, so I would need a way to quickly and securely update all of these workspaces with the same Datasets and Reports.
I think the best next step is to reach out for formal support from Microsoft in creating the paid app, because it is the best solution imo for what you trying to achieve.
If you have further questions, I also suggest that you start a new thread with the specific topic so you can get more visibility from the community.