Forum Discussion

leudyston's avatar
leudyston
Icon for Helper I rankHelper I
8 years ago
Solved

Error while updating dataset manually and by scheduling.

Hello friends, I have a problem in a dataset that until 08/31/2018 normally updated by the schedule, without any explanation this set of data started to present errors in the updates.

 

The point is that in Power BI desktop the manual update works normally, it does not show any error.
The gateway is working perfectly, too.
My biggest difficulty in solving the problem is that the error presented is neither clear nor specific, and I need help to know what might be causing it.

 

 

 

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    leudyston First, always a good idea to make sure you are running the latest gateway version. Second, you can check the gateway log files for more specific errors. The folder location on the server that you installed the gateway on is here -> C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises Data Gateway\Gateway*.log

    • leudyston's avatar
      leudyston
      Icon for Helper I rankHelper I
      8 years ago

      I really can not understand the log files, I have enabled the more detailed log, but I could not identify why the error occurs only in that dataset, because the same data source is being used in other data sets, but it does not this problem.

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi leudyston

    From your screenshot, it seems you install a on-premises gateway and it connect successfully. then you connect to a SQL Server datasource.

    First, please refer to this article to check if you have applied the same steps and selected the same options.

    Manage your data source - SQL Server

    Configuring scheduled refresh

     

    Then refer to the following article to search the similar scenario for yourself.

    Troubleshooting the On-premises data gateway

     

    Additionally, I don't understand the language of yours, could you show some in English?

     

    Best Regards

    Maggie