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 ...
RubenT wrote: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 ...
I tested both of these, they don't work. When I publish a Dataset with parameter X to a workspace that should show data from parameter Y this parameter will be overwritten. Refreshing doesn't help ...
When I publish a Report with a live connection to a Dataset in workspace A to workspace B I then have two Reports with the same name in workspace B, one connected to Dataset A and one to Dataset B (I guess, since it is impossible to see) ...
So other suggestions are welcome! I can't be the only one facing this issue?