Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Report getting failed in Power BI Service while refreshing dataset

Hello All,

I am receiving an error in Power BI service while refreshing data ( Both On-demand and schedule refresh)

Error - There was an error when processing the data in the dataset.

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"}}

Data Records - 13 Million

I have a Power BI report where data is beng imported from Bex Query.

At desktop-level, the refresh works fine, with zero performance issues, and also when publishing it to services again no issue. But when we refresh the dataset in Power BI service I am receiving the above error.

 

Need your help to get this solved.

2 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support

    Hi, Anonymous 

    Are there any other error messages in the refresh history?

    Please recheck the permissions of the data source and the version of the gateway.

     

    Best Regards,
    Community Support Team _ Eason

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi,

       

      Its working for dataset with lesser rows. So, I dont think there is any access related issue. How to handle a dataset with 1.3 million rows or more?