Forum Discussion
Direct Query to Security Tables - Only load once?
Hi jersey417
I would suggest rather putting the tables into import mode and bring them into your model. Even though it is 25 million rows, the table should be small and then make all your subsequent reports a lot faster.
We have other examples where our security tables are 200 million records. I just think this is inefficient as we have some models that have timed out due to the number of rows in the security table. We have some requirements where the security must be relatively live. To full this requirement without a full refresh of the rest of the content/dataset we’re setting up XMLA endpoints to refresh the individual security tables.
It would be ideal to have some option that would direct query the data once and store the content VS refreshing over and over.