Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Advocate I
Advocate I

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.