Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is a dataset related to a single report only?
Is a report related to a single dataset only?
Is dashboard related to a single report only?
Is a dashboard related to single dataset ?
I am confused...
Solved! Go to Solution.
Hi @amirabedhiafi ,
1) In order to display anything on the report, you need data. So once you import data from Excel or database to your Power BI desktop file, you created a dataset for that report.
2) One Report has one dataset, but this dataset can include multiple data sources. Example, you can import data from one csv file, from one Excel file, from sql database. All these different data sources are actually one dataset used for this report.
3) Once you publish your report to Power BI Service, you will see that you actually uploaded 2 things: report and dataset. So as mentioned in previous step, your report has one dataset.
4) But now once this dataset is published, other reports can also use this dataset. You can see that option in Power BI desktop application when you go to Get data > Power BI datasets
5) Dashboard is used on Power BI Service and it is actually combination of different reports. You can take one chart from one report, second chart from another report and combine it in 1 dashboard. Dashboard itself doesn't connect to dataset, it connects (by clicking on dashboard chart) to report that is source for that chart.
Hope this helps.
Regards,
Nemanja Andic
Hi @amirabedhiafi ,
1) In order to display anything on the report, you need data. So once you import data from Excel or database to your Power BI desktop file, you created a dataset for that report.
2) One Report has one dataset, but this dataset can include multiple data sources. Example, you can import data from one csv file, from one Excel file, from sql database. All these different data sources are actually one dataset used for this report.
3) Once you publish your report to Power BI Service, you will see that you actually uploaded 2 things: report and dataset. So as mentioned in previous step, your report has one dataset.
4) But now once this dataset is published, other reports can also use this dataset. You can see that option in Power BI desktop application when you go to Get data > Power BI datasets
5) Dashboard is used on Power BI Service and it is actually combination of different reports. You can take one chart from one report, second chart from another report and combine it in 1 dashboard. Dashboard itself doesn't connect to dataset, it connects (by clicking on dashboard chart) to report that is source for that chart.
Hope this helps.
Regards,
Nemanja Andic
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |