Forum Discussion

deangelodenis's avatar
deangelodenis
Helper I
8 years ago
Solved

Refresh HELP!!

Hi everybody.

 

I need help with the refresh. I'm making something wrong, and I can't realize what is!. 

It's simple, but I don't know where my problem is:

 

1) I have some TXT. and Excel files in my computer, I created a Pbix. file using that dataset.

2) I published (uploaded) the file to the web service.

3) I installed a " On-premises data gateway (personal mode)" in my computer.

4) I edited the credentials for that Pbix file.

 

After that, nothing happens with the refresh. I tried changing some information in the TXT or Excel files, and trying with the manual refresh (and the automatics) and the visualizations don't change. 

 

I'm missing something? I understand that when you make all the work in the desktop and publish the file in the service, each time the dataset change, you're going to see the changes in the service (after the refresh - manual or automatic - ), without using the power bi desktop.

 

Thanks anything you could explain me in order to solve this problem

 

 

  • deangelodenis's avatar
    deangelodenis
    8 years ago

    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.

9 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi deangelodenis,

     

    Did you get any error message?

     

    When you entered the data source credential, did you prompt successful connection?

     

    Please check whether the installed personal gateway service is running.

     

    If you have ever changed windows account after installing gateway, please update the windows account for personal gateway, too. Please check this document.

     

    Regards,

    Yuliana Gu

    • deangelodenis's avatar
      deangelodenis
      Helper I
      8 years ago

      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.

       

      • GilbertQ's avatar
        GilbertQ
        Super User
        8 years ago
        Hi there, just to confirm the TXT files are not open?