Forum Discussion
Solved
M expression(s) not working in SQL queries during refreshes from Portal (Help)
In my Power BI report, I was computing dates using M-expressions. I used these dates in the sql queries without any issue for more than six months since the report's inception. All of a sudden, aro...
Apparently, some recent software update at the PBI portal broke something.
Symptoms: If enhanced dataset mode is enabled in your PBIX, M expressions stop working.
Microsoft has recognized this to be an issue and will provide a fix on 7/21/2020.
"AwarenessPower BI Customers using the Enhanced dataset metadata preview feature may see refresh not complete with the following message "Credentials are required to connect to the File source". As a workaround, users can disable the "enhanced dataset metadata (Preview)" feature in Power BI Desktop. Engineers are working on a fix and expect it to be deployed by end-of-day 07/21/2020."
Does the server have different locale settings? Try specifying the dates as YYYY-MM-DD.