Categories: Power BI

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:

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:

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

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.

View Comments

  • 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..

Recent Posts

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…

5 days ago

dataMinds Connect 2024 – Session Materials

The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…

4 weeks ago

Connect to Power BI as a Guest User in another Tenant

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…

2 months ago

How to use a Script Activity in ADF as a Lookup

In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…

4 months ago

Database Build Error – Incorrect syntax near DISTINCT

I wrote a piece of SQL that had some new T-SQL syntax in it: IS…

4 months ago

Speaking at dataMinds Connect 2024

I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…

5 months ago