Forum Discussion
Refresh HELP!!
SOLVE:
I could solve the issue. I checked all the dates in the .txt and there was some wrong dates, with years like "2108, 9004,...". I filtered or modified that dates, and the service refresh works perfect.
Thanks everybody for the time and to help me.
Yuliana, thank so much for your quick answer and for take time to help me.
I checked everything you said (and the link and video that you shared), and I start all from the beginning. The result was strange, because I could successfully refresh a Dataset (in the BI service) whose data was two excel files (that were in my PC).I felt great and I thought that I solved the problem, but after that I tried with another dataset (which has txt files and excel files), and the refresh failed and I get the msg below.
P.S: Sorry, the image is in spanish. And thanks again.
Hi Gilbert, thanks for try to help me!
No, the TXT are not open.
- Hi there
Just one other thing to check is when you are in Power BI Desktop, click on Edit Queries, then Data Source Settings.
Do the data sources you have there match what you see in the personal gateway?Hi Gilbert,
Thanks again. Yes, I checked like you said, and yes, all match!. And if I refresh from Power BI Desktop, all the information refresh great. The problem is the refreshed from the BI service.
Looking in the community, I found this post that is the same problem that I have:
Someone said that maybe has problem with a Mesaure or with a empty row in the Excel file... THAT could be the reason of the failed refresh? In that case, what can I do? It's so strange because in the desktop works excellente, but in the service not.
Thanks again!!!