cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Luukvv93
Helper II
Helper II

Architecture SSAS live connection to service

Hello community,

I am wondering how a live SSAS connection works in the service. Let’s say we’re running an SSIS job every minute so that the DW is filled with new data every minute, does live SSAS connection mean that the data is automatically refreshed in the service without having to refresh the report ?
1 ACCEPTED SOLUTION
deepu299
Helper V
Helper V

If the data is in SSAS, Power BI service don't need to be refreshed for Live Connection. Does your SSIS job refresh the cubes in SSAS? If yes, you will have the updated data in Power BI everytime. 

 

Power BI Service refresh is needed only for the IMPORTed datasets. 

View solution in original post

1 REPLY 1
deepu299
Helper V
Helper V

If the data is in SSAS, Power BI service don't need to be refreshed for Live Connection. Does your SSIS job refresh the cubes in SSAS? If yes, you will have the updated data in Power BI everytime. 

 

Power BI Service refresh is needed only for the IMPORTed datasets. 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.