Forum Discussion
Gateway Performance Monitoring PBIT Dataformat error
I've experienced the same - I believe this is a regression in the April 2020 version of Power BI Desktop not the Gateway. You'll find it works ok with March 2020. I've reported it here - https://community.powerbi.com/t5/Issues/April-2020-throwing-DataFormat-Error-when-using-Gateway/idi-p/1080336
I'm having the same issue and I'm running the May 2020 update of Power BI desktop.
Looking at the log files produced by the latest version of the gateway (3000.40.15 (May 2020)) I can see that entries with QueryType equal to "Refresh" often have one or two extra values between the "DataReadingAndSerializationDuration(ms)" and "DataProcessingEndTimeUTC" columns.
Below is a screenshot of a QueryExecutionReport log file pulled into Excel. I performed a Text to Data operation using a comma as the delimiter. Manual inspection of the log file also shows that these rows have more columns than they should.
Looks like the logging of Refresh queries in this version of the gateway is not performing to spec.
Getting same error with June 2020 release. Anyone know how to fix?
Hi all, I guess I've found solution.
Let's go to the official documentation: https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-performance
We should set this gateway config file up: Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file in the \Program Files\On-premises data gateway
Please find the parameter ReportFileCount and set it's value to '11'. Save the file and restart the service of the gateway. I think it should help, currently it fixed my problem
