Can no longer publish pbix files to the service where a "Detail Rows Expression" has been set

[DirkVDS]

PBI Desktop Nov'21
"Detail Rows Expression" was set by Tabular Editor build 3.1.7998.273

After you have set a "Detail Rows Expression" on either table or measure, you can no longer publish the file to the PBI Service

Example of Expression used

SELECTCOLUMNS(
  'Sales',
  "Order Number", 'Sales'[Order Number],
  "Quantity", 'Sales'[Quantity],
  "Product", RELATED( 'Product'[Product Name] )
)

When publishing the file to a workspace you receive an error: An error occurred while attempting to publish ‘file name.pbix’: The remote server returned an error. (400) Bad Request.
If you set the Detail Rows Expression back to blank, you can publish the file without any problem.

Does anyone experience the same issues?

[DirkVDS · Accepted solution]

Hi Ibendlin,

Thanks for you reply, but I dind't think there was anything wrong with the syntax (an example from SQLBI.eu did have the same problem and error)

I finally was able to solve my problem.

It seems that setting the "Details Row Expression" in the pbix file requires a Premium workspace.

If I want to upload the file to a Pro workspace, I get the error.

But if I upload it to a Premium or PPU workspace, it just works.

Dirk

[lbendlin]

Maybe this is related?

"Pay attention to the syntax. DETAILROWS is a table function and can be combined with any other DAX expression that allows a table. However, the argument of DETAILROWS should be a single measure and Visual Studio will return a warning if you provide another type of argument. If you use a more complex expression and you deploy it the user will get an error saying “An unexpected exception occurred.” at query time."