Power BI Service error: “This visual has unrecognized fields”

UPDATE: IT SEEMS THE BUG HAS NOW BEEN FIXED. THREE HOORAYS FOR THE POWER BI TEAM!

Recently I stumbled across a quite annoying error in the Power BI service. I uploaded two working reports from Power BI Desktop to the cloud service. Each report connects to its own cube and both cubes are in the same SSAS MD database. On the server, I have a gateway installed that connects this SSAS MD database to the online service.

Now, when I browse one of the reports, everything works fine. Once I open the other report, the visuals of this second report stop working:

missing01

This visual itself displays the error “This visual has unrecognized fields”. A bit odd, since everything worked just fine in Power BI Desktop. When clicking on the See details link, the following pop-up appears:

missing02

Apparently Power BI has trouble to identify some fields (in this case it’s the name of the measure group). What’s curious though, is that some fields of the second report still work. Those fields are attributes of the conformed dimensions. In other words, fields that are shared between the two cubes still work.

I monitored the queries to the SSAS MD database using Profiler: only the working queries came through. Queries from the non-working visuals didn’t even reach the cube. So this means they are stopped before the query is sent to the SSAS MD instance. I did a heavy investigation into the on-premise gateway. I reviewed all of the logs, but nothing spectacular came out. I reviewed all of the HTTPS traffic on the gateway server using Fiddler. With this tool I could retrieve the JSON that was sent between the gateway and the Power BI service. The JSON of the non-working visuals contained the following error message:

Could not resolve model references in the Semantic Query

missing03

The JSON also contained a help URL, but of course it doesn’t work. So for some reason Power BI (either the service or the gateway) can’t find the fields that are being referenced by the visual. However, the queries on the conformed dimensions are sent to the correct cube, so it’s not the case that Power BI is sending everything to one single cube and it ignores the other. Even more, after the weekend I tried again and suddenly the first cube stopped working but the second one worked without any issue. This led me to believe there was some weird caching issue going on.

I posted my findings on the Power BI forum and the Power BI team was quickly to confirm it’s a caching bug when working with multiple cubes in the same SSAS MD database. Apparently they didn’t test with the AdventureWorks cubes? They are currently working on a fix and I hope it’s released soon. I’ll update this blog once I know more.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂

Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

4 thoughts to “Power BI Service error: “This visual has unrecognized fields””

  1. I’d really like to see this fixed asap as well, because it’s giving me issues at clients.

    But, …

    If you restart the Data Management Gateway service and do a hard refresh (CTRL + F5) in PowerBI.com, the caches are reset.

    This ‘workaround’ definitely isn’t suited for production environments, but when you’re in DEV-mode it sure helps if you’re making changes..

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.