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?