OLE DB Error

[Anonymous]

Hello! I have reviewed many forum posts on this problem and none have managed to resolve this problem or hint at a solution. 

I have refreshed every table and query individualy (and successfully at that) however when I hit close and apply, I run into the error shown in the second photo. This error occurs for each of the tables being loaded.  

Any help would be really appreciated. I'm pulling my hair out trying to figure out why this isn't working. 

If you need any additional info or photos, let me know. 

Cameron

[v-henryk-mstf]

Hi @Anonymous ,

For this type of issue, this could be a problem caused by our database permission settings. Some confirmation with the database administrator is required to ensure that the user needs to have the full administrator credentials to access and manipulate the data in the PowerBI query.

Alternatively, you can check if the following similar solutions are helpful to you.

Solved: Re: Error returned: 'OLE DB or ODBC error: [Expres... - Power Platform Community (microsoft.com)

Solved: Failed to save modifications to the server. Error ... - Microsoft Power BI Community

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.