Report Builder no longer running

[aak]

I have a report that was working well until a few weeks ago. It is a paginated report that is connected to a data source in the Power BI Service. When I run the report I get an error that the connection either timed out or was lost. I saw this once before when the credentials in the service weren't correct, but I have confirmed that they are okay. In fact, I created a much smaller report connected to the same data source and it runs just fine.

Now, granted, this report is quite large, but it was working. The only change that I know of was that my IT department switched us from MFA to the authenticator app. I'm not sure if that would have anything to do with it.

Any help would be much appreciated.

[aak · Accepted solution]

The problem turned out to be with the data. For some unknown reason, the last record was causing issues. I deleted it and then recreated it. Everything worked after that.

[v-zhenbw-msft]

Hi @aak ,

Sorry for that, we cannot reproduce the issue here and also not found an effective solution.

We suggest you to open a ticket here for help: https://powerbi.microsoft.com/en-us/support/

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aak]

Thank you for the response. I put in a support ticket and Microsoft is looking at the issue. I will report back once I have a solution.

[v-zhenbw-msft]

Hi @aak ,

Hopefully, it could be resolved soon and it would be great if you could share the solution to help more users.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aak]

So after playing around with this for a very long time today, I realized that the issue is with a single column of a dataset. If I delete that column, the query executes just fine. If I add it back in, it fails.

The second smaller test report with the same dataset and columns works all the time.

Still not sure what the issue is, but I'm hoping that this narrows it down.