Forum Discussion
OLE DB or ODBC error: [DataSource.Error] AzureBlobs
Hi, I'm getting below error.
"OLE DB or ODBC error: datasource.error Azureblobs: The data source appears to have been modified since it was last accessed. Refreshing may resolve this error.."
I am able to load the data into query editor, view it, do manipulations on data but whenever I try to apply the query, it loads for a few minutes and this error pops up. I have tried refreshing and clearing global permissions after reading few solutions, but it still isn't working. Please help me fix it.
17 Replies
Has there been any update on this yet? Looks like the last response was over a month ago. I am also getting this same error.
Hi Anonymous ,
I'm sorry to hear that you are experiencing the issue. I understand that this issue is affecting your business and that you are eager to get it fixed. I appreciate your patience and cooperation while we are working on resolving this issue.
I would like to update you on the status of the issue. The related support engineer still working on it, but it has no date commitment at this time. We are unable to provide a timeline for resolving the bug as there are many factors that contribute to prioritization and completing the changes required. However, we are actively monitoring this issue and we will notify you as soon as we have any updates or changes in the status.
I apologize again for any inconvenience or impact that this issue may have caused you. I assure you that we are working closely with the product group to resolve this issue as soon as possible and that we will keep you updated on the progress. Thank you for your understanding and feedback.
Best Regards
Any updates on this issue? It's critical to my job role that I'm able to access and visualize email marketing data, and I'm unable to do that from our blob storage account. If there's no solution at the moment, is there any alternative means of accessing this data and loading it into Power BI? Thanks!
I have been waiting for an answer from the Microsoft team and I still haven't receieved any update.
A partial solution that I recieved from one of my internal support team was to load data till yesterday, or a date except today. I'm not sure if I'm referring the right solution but as far as I remenber we have been using the above approach.
Hi!
Is there any solution for this problem?
There's no solid solution from Microsoft team and this needs to be brought to their attention.
A partial solution that I recieved from one of my internal support team was to load data till yesterday, or a date except today. I'm not sure if I'm referring the right solution here but as far as I remenber we have been using the above approach.Thanks for the hint. We will try this approach also.
Has there been any further development on this? I'm also experiencing the issue.
The errors are sporadic and seems to be just pot luck based on whether the data refresh conflicts with the csv files getting updated in blob storage. I thought there might be a way to incrementally load the data to avoid conflict but from what I can see all of the files are modified regularly with new data e.g. for email click data there are 9 files and the latest data gets added to 1 of the 9:
So it's not a case of just picking up the latest file. Even some insight into how this data gets loaded into blob would be useful e.g. is it streamed in, or loaded in intervals?
