Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Issues with dataset refresh in Service

Submitted by Anonymous on ‎07-26-2023 06:32 AM

Hi,
Since a couple of days (I believe, since the last update) there seems to be an issue with a dataset refresh. 

Screenshot 2023-07-26 152907.png

Until then, it was working properly, so we assume there was some change on PBI Service side. On Desktop everything works as expected.

@Anonymous 

 

Thank you

Status: Needs Info
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎07-26-2023 06:33 AM

Let me know if you need more info.

 

Anonymous
Not applicable
‎07-26-2023 10:53 PM

Hi @Anonymous 

Does this happen for all datasets or for a specific one, and what is the corresponding data source for that dataset? What is the connection method?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎07-26-2023 11:29 PM

Hi @Anonymous ,

 

For some reason it's just this dataset, but there was no changes to it - it's just stopped working. The source is MS SQL Server database and SharePoint files. Import mode.

 

Regards,

Anonymous
Not applicable
‎07-27-2023 04:36 AM

With trial and error, I've found out that the issue comes from the join of SQL Server table and SharePoint table. If I remove it, the dataset refresh works ok in the Service. Still not clear why the original dataset is only able to refresh on Desktop, and not in Service.

 

Regards,

Anonymous
Not applicable
‎07-30-2023 11:42 PM

Hi @Anonymous 

According to your test, the problem is that there is an issue with the merged data table from 2 data sources, if it's just a single data source, the refresh is successful is it?

 

Best Regards,
Community Support Team _ Ailsa Tao

Anonymous
Not applicable
‎08-02-2023 04:25 AM

Hi @Anonymous,

 

Yes, you've put it correctly. If I keep the merge, the refresh fails, if I remove the merge, both tables refresh correctly in Service. This was different (for some reason) before 22/07. The last successful refresh was on 21/07. 

 

Regards,

Idea Statuses