Reply
Regular Visitor
Posts: 28
Registered: ‎11-23-2017
Accepted Solution

Error while updating dataset manually and by scheduling.

[ Edited ]

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

 

 


Accepted Solutions
Highlighted
Regular Visitor
Posts: 28
Registered: ‎11-23-2017

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

View solution in original post


All Replies
Super User
Posts: 3,484
Registered: ‎06-25-2015

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
Community Support Team
Posts: 2,482
Registered: ‎03-15-2018

Re: Error while updating dataset manually and by scheduling.

[ Edited ]

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

 

 

Regular Visitor
Posts: 28
Registered: ‎11-23-2017

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.

Highlighted
Regular Visitor
Posts: 28
Registered: ‎11-23-2017

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