Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
vnj
New Member

Table Load And Sort Errors

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:

1.PNG

 

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

 

2.PNG

 

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

PBI_Error.PNG

 

 


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,

3 REPLIES 3
Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thanks - have just cross posted

v-yulgu-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.