Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please help!
Solved! Go to Solution.
Problem solved!
Explanation of solutions:
To summarize, all errors were related to language settings in both PowerBI and desktop as tex628 suggested.
My initial settings were English (United States) in both PowerBI and desktop regional settings since two months - everything worked great until yesterday when these errors suddenly appeared!
Following tex628's hints, I switched to English (Belgium), the errors were still there - but my colleague Marc found a workaround by using parenthesis to separate all expressions; all errors were gone.
Finally, I tried to use the same settings as tex628's, meaning all the settings are in English (United Kingdom), then all the original codes are free of errors and there is no need to use the additional workaround mentioned above.
Problem solved and my credits to tex628!
Thank you everyone for your help!!!
Honestly I'm not quite sure what could be wrong here, it might be related to your regional settings.
I believe the issue in error 4 is that the "," should be replaced with a "."
Could you please provide the locale in PBI desktop & your desktop regional settings:
Problem solved!
Explanation of solutions:
To summarize, all errors were related to language settings in both PowerBI and desktop as tex628 suggested.
My initial settings were English (United States) in both PowerBI and desktop regional settings since two months - everything worked great until yesterday when these errors suddenly appeared!
Following tex628's hints, I switched to English (Belgium), the errors were still there - but my colleague Marc found a workaround by using parenthesis to separate all expressions; all errors were gone.
Finally, I tried to use the same settings as tex628's, meaning all the settings are in English (United Kingdom), then all the original codes are free of errors and there is no need to use the additional workaround mentioned above.
Problem solved and my credits to tex628!
Thank you everyone for your help!!!
Regional settings can be a mess! I'm glad that i worked out 🙂
@Anonymous
I'm afraid I can't replicate your error.
My first hunch was that some invalid character has crept into the formula, but I couldn't find any way of producing the same error message.
Could you try re-typing the formula from scratch.
Otherwise, could you share a PBIX exhibiting the error?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |