question

VascoFerreira-6636 avatar image
0 Votes"
VascoFerreira-6636 asked CarrinWu-MSFT commented

If i should use SSAS for my scenario and if so, how would i go about it

Hello,
Currently I'm having issues where i have many PowerBI reports running, however this slows the database sometimes as the views they use take about 30s to execute and they need to refresh pretty often.
I thought about using SSAS this way: i build the view in the SSAS using the tables, and as only two of those tables need to be refreshed more often, i would execute those as directquery's and leave the others as import with a job processing them at longer times.
Problem: i cannot set the individual tables as directquery and import, i can only do so in the whole cube itself.

Should I be using Analysis Services for this? If so, what would be the best way to face this?

Best regards,
Vasco.

sql-server-analysis-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @VascoFerreira-6636, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @VascoFerreira-6636,

Thanks for your posting.

Problem: i cannot set the individual tables as directquery and import, i can only do so in the whole cube itself.

Tabular models in DirectQuery mode have some limitations, such as calculated tables are not supported in DirectQuery models, but calculated columns are. For more information, please refer to DirectQuery mode in tabular models.


Best regards,
Carrin


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.