This refresh error is weird, because the function causing the error doesn't feature in any of the M code !
(At least, not in the M code in the desktop pbix file that designed this report.)
Any ideas?
@TomTomTom - Looks like you are trying to add an Index column in that code. For some reason, I recall this exact error happening to someone else when they were trying to add an Index column. Can you post your Advanced Editor code?
If I recall, dropping the newly added 5th parameter should fix it. So, drop the ", number" part when adding the index.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
@TomTomTom - Looks like you are trying to add an Index column in that code. For some reason, I recall this exact error happening to someone else when they were trying to add an Index column. Can you post your Advanced Editor code?
If I recall, dropping the newly added 5th parameter should fix it. So, drop the ", number" part when adding the index.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
