cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amelia
Frequent Visitor

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 datasets.

For example, say you have a page with 3 bar charts (Orders by Style, Orders by Month & Orders by Color) connected to the same data set of individual order records. I like the way you can create these off the one data set and then they all adjust when you select items with each. But say I also want to show a line chart showing year on year orders for comparision should i create another dataset that has been already aggrigated and just ready to diaplay or is it more recomended to some how aggrigate the current dataset so that you are only doing one trip to the database. Currently as my knowledge of PBI and DAX is not great i find myself tending to create many datasets to do slightly different things.

Thanks

 

E

 

Woman Wink

1 REPLY 1
JayHerrera
Frequent Visitor

@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. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.