Forum Discussion
Data Sets
Hi Quite new to PBI so still finding my feet. I like the idea of having multiple reports in a workspace that can be emebeded into a dashboard but im not sure what best practises is on creating dat...
Amelia - depending on the complexity of the queries you are using and the amount of charts you expect to eventually have within report, it is quite possible that many trips to the database could affect performance. In my humble opinion, I would suggest beginning with one query that contains all of the data you need for each chart. The values you display in each chart are aggregated on the fly anyway so agreggating beforehand in query may not be necessary. If you run into issues with certain fields not being available, for instance month or year to display in a line chart axis you could build the fields in your query with SQL code; that is assuming you are using SQL. Hope this helps! Feel free to respond with further questions.