cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leudyston Regular Visitor
Regular Visitor

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.

errorupdate01.pngerrorupdate02.png

 

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.

 

gateway.png gateway2.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
leudyston Regular Visitor
Regular Visitor

Re: Error while updating dataset manually and by scheduling.

This issue has been resolved in another topic.
The cause of the problem was actually a bug in Power BI Desktop

 

https://community.powerbi.com/t5/Desktop/Error-creating-a-table-from-a-dax-expression/m-p/529184

 

 

Best Regards

 

Leudyston

4 REPLIES 4
Super User
Super User

Re: Error while updating dataset manually and by scheduling.

@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

Near SE WI? Join our PUG MSBIWI
Highlighted
Community Support Team
Community Support Team

Re: Error while updating dataset manually and by scheduling.

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

 

 

leudyston Regular Visitor
Regular Visitor

Re: Error while updating dataset manually and by scheduling.

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.

leudyston Regular Visitor
Regular Visitor

Re: Error while updating dataset manually and by scheduling.

This issue has been resolved in another topic.
The cause of the problem was actually a bug in Power BI Desktop

 

https://community.powerbi.com/t5/Desktop/Error-creating-a-table-from-a-dax-expression/m-p/529184

 

 

Best Regards

 

Leudyston