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: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

muzammil

Power BI, Apply query changes: OLE DB or ODBC error: [DataSource.Error]

Submitted by on ‎07-31-2018 01:02 PM

Power BI connecting with SharePoint, when I try to Apply changes in Power BI Desktop's Query Editor, while applying changes and data transfer which is more than 460 MB, after around 140 MB to 250 MB data transfer it stuck and display the "Apply query changes" error, screenshot is as follows;

Apply-Save-Changes.png

 

Even referesh and following error;

Refresh.png

 

Tried couple of times, but no luck. Please, any ideas or suggestions.

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎08-01-2018 01:52 AM

Hi @muzammil,

 

1. Please reduce data row in Query Editor then apply changes again. 

2. Please check which Power BI desktop version do you run? Please update to the latest version 2.60.5169.4101 then test again.

 

Best Regards,
Qiuyun Yu 

muzammil
New Member
‎08-03-2018 05:46 AM

Hi @v-qiuyu-msft,

 

Thank you for your quick response, really appreciate. before I read your reply, I was finally able to publish the report after couple of tries.

 

I was unable to apply the changes as per your post, before success I was still on version 2.5xxx (April version) which I updated now to latest release.

 

My experience with the issue: Every time I restart the process it increases the number of MB (upload) before through error message... it starts uploading fast and gradually slowdown before stuck and through error.

 

Again, thank you 🙂

Idea Statuses