"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."

zubaid ahmed 0 Reputation points
2023-10-25T20:03:28.8633333+00:00

One of the users receive this error. is this issue at our end or at microsofts ?

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,649 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,684 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Alberto Morillo 33,341 Reputation points MVP
    2023-10-25T21:10:38.8133333+00:00

    Let's see what the cause could be. The following are a few things you can try:

    1. Try to temporarily disable Windows Firewall or any security software on the computer used by that user, and try again.
    2. Make sure you can access Azure data sources from other tools on the same computer like SQL Server Management Studio and Azure Data Studio. Try to connect from other hosts on your organization. Sometimes new corporate firewall rules or policies may block access to Azure data sources or temporary health issues of Azure resources.
    3. Sometimes the document the user is using needs to be trusted. Please read here.
    4. Sometimes reinstalling OLEDB or ODBC drivers or using the latest versions of those drivers may do the trick.
    5. Close open documents and restart the computer.
    1 person found this answer helpful.
    0 comments No comments

  2. Gabriel Roldan 25 Reputation points
    2024-05-28T13:30:39.0233333+00:00

    I see this post was never updated. I have, or better, everyone in the company has this issue:
    User's image

    The file has a connection to an Azure Analysis Services server that uses the authenticated user to log on:
    User's image

    The problem is, when opening this file after rebooting, the error occurs and even though the connection is saved in the file, we have to go through the connection wizard again to be able to use the pivot tables. It has nothing to do with the drivers.

    Could the issue lie in the configuration of the server user mapping?

    When creating the connection through Power Query, the connection would work only when selecting the 'Microsoft Account' option, for which we use the same user and password as the 'Windows Credentials', but when trying to use the latter as the connection option, it fails.

    Any insights? This issue has been ongoing for month and no one seems to find a solution.