Forum Discussion

kostaszogo21's avatar
kostaszogo21
Frequent Visitor
4 years ago
Solved

Real-time data in PBRS

Hello guys! Newbie here so i would appreciate all the help i can get from you. It's my first project in Power BI, so i am gonna  try and explain my problem with as many details as possible: we're...
no incremental refresh
PBRS
  • d_gosbell's avatar
    d_gosbell
    4 years ago
    kostaszogo21 wrote:

    do you mean because i will be using DirectQuery to connect to Analysis Services (once i have created these partitions) ? Or is there another reason for that?

    Technically it uses a Live Connection when connected to SSAS, but conceptually that is similar to DirectQuery in that the Report Server does not host the data, it just sends queries out to SSAS. Therefore you have to schedule any refresh operations using the SSAS tools/ APIs.

     

    kostaszogo21 wrote:

    Sorry for asking again, but it's vague for me if once i have created these partitions i should use Import Mode or DirectQuery.

     

    You could use either, but if you only need to refresh every 20-25 minutes you could probably using import mode as that will give you the fastest possible query speed

     

kostaszogo21's avatar
kostaszogo21
Frequent Visitor
4 years ago

Thanks again for all the help d_gosbell .

 

When you say that

" You cannot schedule SSAS refreshes using the PBIRS scheduled refresh feature so you don't need any of those setup if you are using SSAS."

do you mean because i will be using DirectQuery to connect to Analysis Services (once i have created these partitions) ? Or is there another reason for that?
Sorry for asking again, but it's vague for me if once i have created these partitions i should use Import Mode or DirectQuery.

Thanks again,
Kostas 

d_gosbell's avatar
d_gosbell
Super User
4 years ago
kostaszogo21 wrote:

do you mean because i will be using DirectQuery to connect to Analysis Services (once i have created these partitions) ? Or is there another reason for that?

Technically it uses a Live Connection when connected to SSAS, but conceptually that is similar to DirectQuery in that the Report Server does not host the data, it just sends queries out to SSAS. Therefore you have to schedule any refresh operations using the SSAS tools/ APIs.

 

kostaszogo21 wrote:

Sorry for asking again, but it's vague for me if once i have created these partitions i should use Import Mode or DirectQuery.

 

You could use either, but if you only need to refresh every 20-25 minutes you could probably using import mode as that will give you the fastest possible query speed