Forum Discussion
Merging Common Dimensions
Hi All, I am going through a very rare scenario where I have 2 Datasets built from dataflow. The datasets names are DS1 and DS2 which are Direct Query based Now I wanted to design a report based o...
My recommendations:
- Use a central date dimension table, where the "date key" is related to both DS1 and DS2 with 1-n relationships
- To improve report performance, use Import mode. "millions" of rows does not really justify using DirectQuery in my opinion. Import mode should be able to handle millions of rows with no issues, as long as you are disciplined about the number of columns and data types you are importing.
My recommendations:
- Use a central date dimension table, where the "date key" is related to both DS1 and DS2 with 1-n relationships
- To improve report performance, use Import mode. "millions" of rows does not really justify using DirectQuery in my opinion. Import mode should be able to handle millions of rows with no issues, as long as you are disciplined about the number of columns and data types you are importing.