Forum Discussion
Report pages loading delay issue
nandic hackcrr lbendlin Hi Guys , I did a Poc and checked the performance of the report when I remove the ad-hoc files which are coming from the sharepoint source . My reports are working superfast when I am using the datalake only as the source .
But , the issue is , the files coming from sharepoint are also vital for the reports as they also are useful for certain columns being used for DAX .
Please help me in this .What can I do to make the reports fast even when I want to use the sharepoint files ?
Anonymous , it is great that you managed to find what is the main issue. That is our starting point. Now next stage comes, data model optimization.
In that case we would need at least these information:
1) how are these sharepoint files (tables) connected to existing model? Are they related directly to main (fact) tables? Is it using 1>many relationship or many>many, is it using single or both cross-filter direction
2) how are these sharepoint tables used in above mentioned DAX? Show on example of one measure the full lineage how these sharepoint files impact DAX logic
3) are these sharepoint tables used as start or snowflake schema? Screenshot of data model with marked fact tables and sharepoint tables would be very benefitial
