Unable to Connect or Expression.Error

Problem

If you're opening Power BI from a PBIDS file generated from Dremio or if you're connecting to Dremio from PBI Desktop, such as when opening a parquet file in PBI Desktop, you may see this error:

This report format is no longer supported. Please recreate the report and set Encryption to Disabled.

Solution

PBIDS fix

The PBIDS file may be edited with a text editor to add the encryption parameter, as shown here:

PBIDS file

{
  "connections" : [ {
    "options" : { },
    "mode" : "DirectQuery",
    "details" : {
      "address" : {
        "server" : <your_server>,
        "schema" : "Samples.samples.dremio.com.tpcds_sf1000.customer",
        "object" : "1_0_0.parquet",
        "encryption" : "Disabled"
      },
      "protocol" : "dremio"
    }
  } ],
  "version" : "0.1"
}

Non-PBIDS fix

Use this solution if you are trying to create a report or connect directly from Power BI Desktop. In some circumstances, the error reported is incorrect, so this solution will allow you to find the correct error.

Install Power BI Desktop (May 2022) and recreate the report or connection using the May 2022 version. This is because May 2022 has better error reporting than the June 2022 version. Once the error is determined and fixed, then the June 2022 version can be installed again.