Error on Refresh in Power BI Service, not on desktop

[bgeels1]

Hello,

I am getting the same error repeatedly when one of my PBI reports refreshes in the Power BI service. The same PBI report refreshes fine in the Desktop Version. The error is attached below.  I am having a hard time isolating the issue.  There are three datasources in the PBI report:

1. QuickBooks Online connection

2. API connection to Monday.com

3. Excel worksheet located on my local machine

Based on the error, it appears that the error is related to the QuickBook Online connection, but there isn't much there to tell me what to change to have it start working again. For context, the same model was setup on auto refresh and was working fine until about mid-June.  I have been getting this error for about a month and I don't know how to fix it. 

I have tried: (1) updating the Privacy Level to Organizational, (2) reinstalling the Gateway, (3) refreshing the authentication credentials. None of these solutions worked. 

Any pointers would be appreciated.

Thank you!

[Mahendrachowdar]

I am also getting the same error repeatedly when one of my PBI reports refreshes in the Power BI service. The same PBI report refreshes fine in the Desktop Version.  I having a hard time isolating the issue. The data source is Salesforce

[rsovitzky]

I encountered the same issue: not being able to use the QBO connector on a Gateway until I followed the steps outlined in the prior post.

11-05-2021 08:16 PM

I encountered this myself. The fix was to download your own Simba QuickBooks ODBC driver, then get the missing file from that driver, paste it into the provided path, and restart the Gateway

[bgeels1 · Accepted solution]

For me, we realized that the QuickBooks Online driver does not support having an On Prem data source (I had an additional data source that was an excel file on my local machine). This error went away when I moved the excel file to a SharePoint datasource. 

[powerbiTF]

I encountered this myself. The fix was to download your own Simba QuickBooks ODBC driver, then get the missing file from that driver, paste it into the provided path, and restart the Gateway

[GilbertQ]

I would look at the documentation for QuickBooks and where it installs the file to.

[bgeels1]

how do you know it's QuickBooks installing the file there? It looks like a Microsoft file path to me. if you search for the file "QuickBooksODBC.mdef" on Google, there isn't anything that comes up.  

[GilbertQ]

Hi @bgeels1 

From the error screen it appears that it has to do with the configuration file for Quickbooks.

If you could check if something has changed with Quickbooks and their config file?

[bgeels1]

Hi @GilbertQ 

If I navigate to the file location (from the error message) on my disk, I am able to get there, but there is no QuickBooksODBC.mdef file there.  Perhaps the absense of this file is what is causing the error?

This looks like a Microsoft file location as opposed to QuickBooks file location (see the file path, its inside a Microsoft folder).

Any idea how you one would fix this?