Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

April 2020 throwing DataFormat.Error when using Gateway Performance PBI template file

Submitted by Anonymous on ‎05-07-2020 06:03 PM

On the April 2020 version of Desktop, downloaded the Gateway Performance PBI template file  and pointed it to my gateway logs.

In the query editor, both the "QueryExecutionReport" query and the "DataError" query both error with the following:

 

DataFormat.Error: There were more columns in the result than expected.
Details:
Count=11

 

The problem appears after the Table.ExpandRecordColumn step - in the QueryExecutionReport I get it when I try to do the Table.Group step (I repeated the action in the UI to see if that had change) and in DataError the problem also occurs after the Table.ExpendRecordColumn step, but when you try to filter the rows for where the expanded JSON equals true.

 

Works correctly in : Version: 2.79.5768.663 64-bit (March 2020)
Doesn't work in : Version: 2.80.5803.1061 64-bit (April 2020)

Status: Accepted
See more ideas labeled with:
10 Comments (10 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎05-11-2020 02:32 AM

Hi @Anonymous, 

 

I can reproduce the issue on my side. Will report it internally soon. 

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support
Community Support
‎05-12-2020 12:27 AM

Hi @Anonymous, 

 

I already reported this issue internally: CRI 187792258. Will keep you update here once I get any information. 

 

Best Regards,
Qiuyun Yu

v-qiuyu-msft
Community Support
Community Support
‎05-12-2020 12:28 AM
Status changed to: Accepted
 
colivier
Advocate I
Advocate I
‎06-03-2020 04:14 AM

Getting the same issue. Looks like Refresh query log entries are outputting additional fields in the log.

Please see my the following post for details: https://community.powerbi.com/t5/Desktop/Gateway-Performance-Monitoring-PBIT-Dataformat-error/m-p/11...

luukov_nedap
Frequent Visitor
‎06-30-2020 02:51 AM

Getting the same issue here on Version: 2.82.5858.641 64-bit (june 2020)

rhalabi
Helper I
Helper I
‎06-30-2020 11:26 AM

Getting same error with June 2020 release.  Anyone know how to fix?

Patrice
Regular Visitor
‎07-30-2020 02:22 AM

Same error with July 2020 release of the Gateway.

Anyone can help ?

Joe_Doe
Frequent Visitor
‎01-03-2022 03:15 PM

Same issue on latest release of the gateway (December 2021).

Anonymous
Not applicable
‎07-09-2022 02:57 PM

Still present in Version: 2.106.883.0 64-bit (June 2022)

Riktastic
Frequent Visitor
‎11-30-2023 05:15 AM

Hate to say this, but this is still present in the November update of 2023.

There currently is not a way to easily debug the On-premises data gateway. While it is for my customers and myself included the most troublesome part of the Power BI systematic.

 

@v-qiuyu-msft sorry to bother you with this ancient issue, do you have a status update?

Idea Statuses