Refresh is failing in Power BI server (sometimes) but working in Desktop.

[atulbansal82]

I am using ODBC driver custom connector and using this I created a workbook with multiple charts and tables in several sheets. Then tried refreshing in Power BI desktop everything is working fine there but in server it fails sometimes.

Error:

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We're sorry, an error occurred during evaluation."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: deals_table.

Error comes with different table everytime.

[KMSudharsan]

@atulbansal82 , I am also facing same problem with the ODBC datasource. Can someone help me with some tricks or solutions to overcome?

[v-aatheeque]

Hi @atulbansal82 ,

Thanks for reaching out to the Microsoft Fabric Community Forum.

Error Code: DM_GWPipeline_Gateway_MashupDataAccessError

This indicates there is a problem in the data pipeline while accessing or processing the data from the source.

Here are some steps to troubleshoot and resolve the issue:

1. Ensure that your Power BI gateway (if using one) is connected to the data source properly and that there are no issues with the connection.
2.Verify that the credentials used to access the data source are correct and have the necessary permissions.
3.Try refreshing the data to see if the error occurs consistently or intermittently.
4.Ensure the ODBC driver is installed on all machines running the Power BI Gateway.
Check if there are any specific configuration requirements for the ODBC driver in terms of networking, permissions, or service accounts.
5.Go to the Power BI Service, navigate to the Data Source Credentials section under your dataset settings, and ensure they are correct.Test the credentials by manually refreshing the dataset.

You can check the similar solved case : Solved: New ErrorCode=-2147467259 - Microsoft Fabric Community

If this post was helpful, please consider marking Accept as solution to assist other members in finding it more easily.

If you continue to face issues, feel free to reach out to us for further assistance!

[atulbansal82]

Hi  @v-aatheeque ,

Thank you for your response and the suggestions provided. We have tried all the recommended options; however, we are still encountering the same issue. While the refresh works as expected in Power BI Desktop, it intermittently fails in Power BI Service. 

FYI, we are using our own custom ODBC driver developed specific to our internal usecase.

[v-aatheeque]

HI @atulbansal82 ,

Apologize for the issue you are facing.

In this scenario i suggest you to raise a support ticket here. so, that they can assit you in addressing the issue you are facing. please follow below link on how to raise a support ticket:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

[atulbansal82]

Hi @v-aatheeque 

It is requesting a support plan. Currently, we do not have an active support plan in place. Could you kindly clarify if it is necessary for us to purchase one at this stage?

Thank you!

[v-aatheeque · Accepted solution]

Hi @atulbansal82 ,

Please follow the below steps to raise a support  tickect :

Select fabric admin and management and write the issue in help box and go for the solution as shown in the below image :

• In solution select the topic of your issue related and also it ask some addiction details provide as your requirement and click on next.
  
  
  • It will moves to support page and here click on Microsoft subscription as shown in the below image and follow with remaining details.
    
    

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

[v-aatheeque]

Hi @atulbansal82 ,

We haven’t heard back from you in a while, so we’ll be closing this thread for now. If you still need assistance or encounter any issues in the future, please don’t hesitate to reach out by creating a new post in the Fabric Community.

Thank you for being a valued part of the community, and we’re always here to help when you need us!