Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.