Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Report pages loading delay issue

Hi Folks , We are facing issues in 2 of our PBI reports , these reports are created using Datalake semantic model with Some DAX measures coming directly from there . But we are also having certain ...
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

nandic lbendlin 
Answers to your questions:
1.We are using snowflake schema i.e Our manual files(sharepoint tables) are connected to the dimension tables via many to many relations.
2.There are some transformations done in Power Query editor on top of these manual files.Transformations are of the nature - Merged some tables ,created new table which we are using and aggregate functions are being used to populate the columns in the tables like addition , division ,multiplication etc.
3.The merged files also have a relation with dimension tables and are being used for DAX query calculation creation.
4.DAX which are using is similar to  MTD and YTD of the previous one (which I pasted in another reply ) ,just the columns are from the tables of manual files .