cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aak
Helper I
Helper I

Error in report builder

Hi, I am having a problem with report builder and don't know where else to put this. 

 

I have a report that I built in Report Builder that has a Power BI dataset as the datasource. Everything was working fine until I went and refreshed the dataset. Now I am getting an error in Report Builder saying "An error has occurred during report processing. Cannot read the next data row for the dataset 'xxxxx'. The connection either timed out or was lost. The operation has timed out."

 

I went into the web app and downloaded the .pbix and redid my credentials thinking that was the problem, but it didn't solve it. Any help would be much appreciated.

1 ACCEPTED SOLUTION

It's been a while, but if I remember right, it was an issue with the data. The data starts out in a SharePoint list. I deleted the last record and re-added it. Once I did that, the report ran just fine.

View solution in original post

8 REPLIES 8
Sri_1234
Frequent Visitor

Hi,Have the issue been resolved? If Yes, Could you please tell how to solve.We are having the same issue.

 

Thank you,

Sri

It's been a while, but if I remember right, it was an issue with the data. The data starts out in a SharePoint list. I deleted the last record and re-added it. Once I did that, the report ran just fine.

Sri_1234
Frequent Visitor

Thank you for your reply.I really appreciate it. 

Greg_Deckler
Super User
Super User

@aak - Tough to troubleshoot, You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler - Thanks, I think I will go ahead and put in the ticket. I'll report back when I have an answer!

v-xicai
Community Support
Community Support

Hi @aak ,

 

Have the issue been resolved? If Yes, could you please show us the solution to help others having the similar issue and accept it as the solution ? We will appreciate you so much, thanks.

 

Best Regards,

Amy 

No, it hasn't been resolved. I am currently working with Microsoft to fix it. I'll post the solution when I have it.

amitchandak
Super User
Super User

@aak , this either host is not reachable and credentials. Check the ip of the machine where it errors out is whitelisted or allowed. 

In case you need using gateway , refer

 

Troubleshoot gateway
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot
https://guyinacube.com/2016/09/21/troubleshooting-connectivity-tips/
https://www.youtube.com/watch?v=mGnNn6gnrKk

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors