Countrows in Report Server -Direct Query Mode
Hi, we encountered with the following error while using the balance bucket formula: Bal_Bucket = CALCULATE(DISTINCTCOUNT('MISREP.UTK_T_LIAB_AVG_BAL_NEW'[IACLINK_ACTUAL_ACNUM]), FILTER( VALUES('MISREP.UTK_T_LIAB_AVG_BAL_NEW'[CURRENT_BALANCE_ASON]), COUNTROWS( FILTER(Bucket, 'MISREP.UTK_T_LIAB_AVG_BAL_NEW'[CURRENT_BALANCE_ASON]>= Bucket[MIN] && 'MISREP.UTK_T_LIAB_AVG_BAL_NEW'[CURRENT_BALANCE_ASON]<Bucket[MAX])) > 0)) Also we discovered that there is no option as "Allow unrestricted measures in DirectQuery mode" in Report Server. What is the solution for the above problem?
Refresh is possible in Salesforce?
Hi Guys, Hope you all are doing well. I have a confusion regarding the refresh feature in the PBI report server. As I know, As Power BI Report server has some limitations, schedule refresh is not possible for Salesforce. Currently I have 2 dashboards: Pace 9 : where I am using 2 sources: Oracle and Salesforce Sonia Reports : Where I am using only Salesforce source. My queries: For Sonia Report: If dashboard is currently link with Salesforce, am I seeing the latest data or should we need to refresh it every time manually? I know it does not support schedule data refresh, so I can’t set the time for it to refresh. But does that mean I am seeing the latest data since it connected to salesforce ? Pace 9: For PACE 9 I am using 2 sources : Oracle and salesforce . For Oracle : I am using the import mode and not direct query as direct query option is not available for Salesforce. In this case, if I need to refresh , do I need to refresh it every time by going to Power BI RS tool, importing the new data and then uploading it into the server ? Salesforce Connection: Oracle connection: Thanks again for your time, Regards
