Report getting failed in Power BI Service while refreshing dataset

[Anonymous]

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.

[v-easonf-msft]

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]

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?