03-14-2016 05:58 AM
It is easy to identify which report a tile is coming from.
1/ But how to identify the data set a report is based on? Is there a direct way without looking for table names in the dataset
2/ And how to know where the dataset come from? the path of the file? Was it published from BI Desktop? or is it getting data from an Excel file somewhere?
I have lost track of what I did and do not know where my source data are anymore
03-18-2016 12:42 AM
I am also facing similar issue with my Datasets. Started with few data sets, but then got many more involved, and few are even multiple versions of same dataset. So even table names are also common for few of them. The Datasets are named with appropriate dates (Dataset_17March) but looking at reports, how do i identify which Dataset the data belongs to.
I intend to clean up the PowerBI environment a bit, but again, i know that deleting a wrong dataset would delete corresponding reports and dashboards as well. So not able to delete anything, and thus not able to manage the environment.
Did you get any way around this?
03-18-2016 10:41 AM
I only have a couple of datasets so this is not as big of an issue for me. I try to name my reports according to my datasets. My Purchase report is pulled from my purchase model. My sales reports are pulled from my sales model.
I know that there has been an idea voted up on allowing folders. I believe this would help as you could label the folders off the dataset but as of now, that has not been implemented.
For now, I will continue my naming scheme.
Is it possible to check the fields within the report to decide where it came from? Find a unique field and check the dataset for it?
03-20-2016 02:36 PM
There are a couple of indirect methods to deduce which dataset your report is using:
1) Go to the content pack creation page and click the checkbox for your report. The dataset that your report is referencing will automatically be checked when this happens.
2) Go to the dataset management page (gear icon in top right->Manage personal storage). This will give you the list of datasets and for each dataset it will tell you what reports are built from it. Since it's giving you the reverse mapping of what you want it can be a little noisy if you have many datasets/reports, but it should still have the information that you need.
03-21-2016 06:00 AM
Thank you, these are indeed 2 ways that answer my first question.
Do you have any suggestion regarding my second question: how to trace a data set back to its source?
03-21-2016 01:12 PM
Unfortunately I don't think there is anything you can use to determine whether the original source of the dataset was an Excel/pbix file and where it came from.
Please feel free to vote for the idea on our ideas forum: https://ideas.powerbi.com/forums/265200-power-bi
04-05-2016 12:35 AM
06-22-2016 09:26 AM
We ran into this issue as well, and some of our datasets had the same tables so I had no idea which was which when I was in the reports (which was when I wanted to know). We had access to all our datasets so what I did was went back and created a table called 'What Data Is This' and in it was simply this SQL query:
SELECT 1 as 'DataSetName'
This way when I was in a report, I could open the 'What Data Is This' and see the name. If you wanted it displayed on your report then just change around the query. We just have powerpivot excel workbook and a few cubes, so name only was enough but you could easily add additional columns to specify where it was from (Power BI Desktop, Excel, Tabular, etc).
06-30-2017 04:39 AM
Hi All ,
Greetings for the day ,
I am also faced this issue in my project , i found one solution when i exploring the solution for this question.
If you are admin of the power BI report , you could able see the icon 'View related' in the top right under settings icon buttion ,if you can click on 'View related' buttion ,you will see the respected data sets and Dashboards .
06-30-2017 04:49 AM
Greetings for the Day,
I am also face this issue in my project , i would like share my solution here , i was explore one solution when the time of identifing solution in power BI report.
If you are Admin of the power BI report you people can see the 'View Related' icon option at top right most under settings icon buttion , if you click on 'View Related' button you can see respected Datasets and Dashbaords as well.
Hope this will Help