https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-paginated-reports-aggregation-or-details/m-p/3173345#M35580 <P>Hello,</P><P>&nbsp;</P><P>In my opinion Power BI is a tool to steer and/or analyze you business.&nbsp;<BR />Analysis depends from which perspective(s) the end-user looks at his business.<BR />If you ask the user if he also wants detail transactions, sometimes he says 'Yes'.<BR />OK, but why do you need them? Answers may be different, sometimes for incident management. Which in my eyes you should not use Power BI for (better use some operational tool).<BR /><BR />I am always a little bit reluctant in also embedding all the detail transactions in an Import dataset. We have tables with million of records, some with a billion a year. Why am I reluctant?<BR />- Import dataset might become too big?? (We have premium capacity)</P><P>- Maybe I need to create a composite model with it's advantages but also disadvantages</P><P>- How often do they really use the details?</P><P>&nbsp;</P><P>How are other people doing this? Are you also struggling with this?&nbsp;<BR />Or should you, when the ultimate future goal is self service BI, just dump everything in a shared dataset?<BR /><BR />Another question:<BR />Sometimes you see that people build some kind of a search function in a Power BI report. You can type in an account number or so and then you get a list of transactions. Isn't this more functionality for paginated reports?<BR /><BR />Regards<BR />Ron<BR /><BR /><BR /></P> Wed, 05 Apr 2023 08:54:12 GMT Anonymous 2023-04-05T08:54:12Z https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-paginated-reports-aggregation-or-details/m-p/3173345#M35580 <P>Hello,</P><P>&nbsp;</P><P>In my opinion Power BI is a tool to steer and/or analyze you business.&nbsp;<BR />Analysis depends from which perspective(s) the end-user looks at his business.<BR />If you ask the user if he also wants detail transactions, sometimes he says 'Yes'.<BR />OK, but why do you need them? Answers may be different, sometimes for incident management. Which in my eyes you should not use Power BI for (better use some operational tool).<BR /><BR />I am always a little bit reluctant in also embedding all the detail transactions in an Import dataset. We have tables with million of records, some with a billion a year. Why am I reluctant?<BR />- Import dataset might become too big?? (We have premium capacity)</P><P>- Maybe I need to create a composite model with it's advantages but also disadvantages</P><P>- How often do they really use the details?</P><P>&nbsp;</P><P>How are other people doing this? Are you also struggling with this?&nbsp;<BR />Or should you, when the ultimate future goal is self service BI, just dump everything in a shared dataset?<BR /><BR />Another question:<BR />Sometimes you see that people build some kind of a search function in a Power BI report. You can type in an account number or so and then you get a list of transactions. Isn't this more functionality for paginated reports?<BR /><BR />Regards<BR />Ron<BR /><BR /><BR /></P> Wed, 05 Apr 2023 08:54:12 GMT https://community.fabric.microsoft.com/t5/Report-Server/Power-BI-paginated-reports-aggregation-or-details/m-p/3173345#M35580 Anonymous 2023-04-05T08:54:12Z