Table Load And Sort Errors

[vnj]

Hi PBI Support,

There are currently some reproducible errors in the Power BI service when trying to

1. Load a Table visulisation with conditional formatting applied across many columns
2, Sort a Table by one of the columns with conditional formatting

Setup is:

SSAS cube on SQL 2016
Compatibility Level 1200
Version 13.0.4457.0

Accessed though Live Connection via On-Premise Data Gateway

Screenshots below:

1. The Table when it correctly loads with Metric 2 sorted by defaulted. This Table has been cut down from the original 10 columns so it loads correctly:

2. When trying to sort by the Metric 1, 3 or 4 columns, an error message appears:

3. Error details don't reveal any useful client side information:

Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID 64435ec4-8100-4f8f-bc77-e0726ea070ee
Request ID b9b5259d-9bb0-c455-9dcc-0f0aaf898831
Correlation ID e7984b28-6aec-b118-d208-43860f1a4c82
Time Tue Dec 12 2017 10:24:20 GMT+1100 (AUS Eastern Daylight Time)
Version 13.0.3419.168
Cluster URI https://wabi-australia-southeast-redirect.analysis.windows.net

Other points:

1. If the report is exported as a PBIX and loaded into the latest November release of Power BI Desktop using Live Connection, the Tables load without issue. This seems to confirm a server side issue with Power BI service

2. SQL Server Profiler shows the query being correctly sent from Power BI service to the cube and the result being returned. Again, this seems to confirm a server side/processing issue with Power BI service

Thanks,

[Greg_Deckler]

I think you need to submit this at https://support.powerbi.com.

[vnj]

Thanks - have just cross posted

[v-yulgu-msft]

Hi @vnj,

I could not reproduce the same problem in my environment. I would suggest you create a support ticket for further analysis. If you get any valid solution, appreciate you could share it here so that it can benefit more users.

Regards,

Yuliana Gu