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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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".


Follow on LinkedIn
@ 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!:
The Definitive Guide to Power Query (M)

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.