Forum Discussion

jujiro-eb's avatar
jujiro-eb
Helper I
6 years ago
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...
Need Help
  • jujiro-eb's avatar
    jujiro-eb
    6 years ago

    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.


    "Awareness

    Power 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."
jujiro-eb's avatar
jujiro-eb
Helper I
6 years ago

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.


"Awareness

Power 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."
  • ITSNev's avatar
    ITSNev
    Frequent Visitor
    6 years ago

    If you cannot wait until 21st, then you can recover from an auto created backup.
    https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-enhanced-dataset-metadata#report-backup-files

    Report backup files

    Updating a report to use the enhanced dataset metadata feature is irreversible. During the update, however, a report backup file is create to save a version of the report in its original (pre-update) format. The backup file is removed after 30 days.

    To locate the backup report file, do the following:

    1. Navigate to the following location: C:\Users\<user>\AppData\Local\Microsoft\Power BI Desktop\TempSaves\Backup. If using the Microsoft Store version of Power BI Desktop, use the following location: C:\Users\<user>\Microsoft\Power BI Desktop Store App\TempSaves\Backups
    2. Find a copy of the report there with the name and time stamp of the original file.
    3. Copy the file to a location you would prefer, in order to preserve it.
    4. Make sure the Enhanced metadata format preview feature is disabled in Power BI Desktop if you choose to open or use that original file.

    The backup file is created when the report is upgraded, so any changes made after the upgrade are not included. New reports created when the Enhanced metadata format feature is enabled do not have a backup file.

    • ITSNev's avatar
      ITSNev
      Frequent Visitor
      6 years ago

      This now seems to have been fixed my Microsoft.