Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello Gurus,
I am working on an existing report and creating a measure to calculate RRI like in excel.
I was able to use RRI function when I am connected to local excel file but can't access RRI in Power BI Desktop when connected to Analysis Services (tabular cube). any help is much appreciated.
Best,
SM
Hi Amit,
It says here that RRI is not possible with Direct Query. Could this the reason why it;s not available with Analysis Services (Tabular Cube) Live Connections?
https://learn.microsoft.com/en-us/dax/rri-function-dax
Hello @amitchandak , @sabilahmed ,
It looks RRI is not working only if I connect to "Analysis Services" (Tabular cube).
Hello @amitchandak ,
Thanks for sharing the video. When I try to use RRI in Power BI desktop with live connection it shows as if RRI is not a valid function. If I open Power BI that has excel data source, I can see RRI function.
Is there any limiatation on live connections?
Regards,
SM
@smdataanalyst , You have RRI in dax
Power BI Financial Magic: 10 Recently added Function part 2-5/10- PPMT, IPMT, CUMIPMT, CUMPRINC, RRI -https://youtu.be/6oaSdjZ_FLQ
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!