Forum Discussion
Simon3
3 years agoFrequent Visitor
OLE DB or ODBC error: [DataSource.Error]
Hello everyone, I am working on a large dataset with 1.8M rows and 150 columns, until a few days ago everything was working fine then I did some transformation and now when I load the query in Powerb...
halfglassdarkly
3 years agoResponsive Resident
One cause for the OLE DB or ODBC error on refresh can be the data privacy settings being mismatched for different data sources.
Try checking the privacy level for each data source or changing the setting for the current file to ignore privacy levels and see whether that helps.
- Simon33 years agoFrequent Visitor
Unfortunately, this did not solve the issue.