Hi, once again an amazing video, I have couple of questions not related to this topic but very important. First Q, can iterators (e.g sumx) function can be used to Direct query mode. If yes, then is it advised to use ? Secondly, once I schedule auto refresh(dataset) in power bi service, does the report/dashboard/apps also get updated or I have to click on refresh button to get them updated? Look forward to hearing from you soon.
Thank you, Kamal for your feedback. Iterator DAX function do not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. However, if you don't have such requirements then you can use them. Secondly, once you schedule auto refresh in Power BI Service, your reports/dashboards/apps would get automatically updated. Here, you should remember that, if your report/dashboard/app is currently open, and in between, your datasets gets updated, then you might need to refresh report page or visuals.
@@BIConsultingPro further to this, i have gone through all of the videos you made on DA-100 and I want to appear for the same asap. Could you please help me or guide me with some content so that I feel confident? Look forward to your response
![ไข้ขึ้นเลย! เมื่อแฝดโดนจัดเต็มวัคซีนครบ2เดือน🤒 [cc] แดนแพทตี้ SS2 | EP.54 |](http://i.ytimg.com/vi/z2VHItnyyvY/mqdefault.jpg)
Please don't forget to share your feedback!
Explained well.👍
Hi, once again an amazing video, I have couple of questions not related to this topic but very important. First Q, can iterators (e.g sumx) function can be used to Direct query mode. If yes, then is it advised to use ? Secondly, once I schedule auto refresh(dataset) in power bi service, does the report/dashboard/apps also get updated or I have to click on refresh button to get them updated? Look forward to hearing from you soon.
Thank you, Kamal for your feedback. Iterator DAX function do not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. However, if you don't have such requirements then you can use them. Secondly, once you schedule auto refresh in Power BI Service, your reports/dashboards/apps would get automatically updated. Here, you should remember that, if your report/dashboard/app is currently open, and in between, your datasets gets updated, then you might need to refresh report page or visuals.
@@BIConsultingPro Hi, much appreciated help.
@@BIConsultingPro further to this, i have gone through all of the videos you made on DA-100 and I want to appear for the same asap. Could you please help me or guide me with some content so that I feel confident? Look forward to your response