Power BI refresh issue

[Anonymous]

Hi,

I have issue with power bi schedule refresh.

Frequently I am getting one or the other error message below for schedule refresh.

1)

Data source error: The operation was throttled by Power BI Premium because there were too many datasets being processed concurrently. Please try again later

2)
Underlying error code: -2147467259 Table: Tablename.
Underlying error message: ODBC: ERROR [HY000] [Microsoft][ImpalaODBC] (110) Error while executing a query in Impala: [HY000] : Runtime Error: Query 474fbd9c794bc89c:e103524500000000 100% Complete (1 out of 1)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Impala
Microsoft.Data.Mashup.ValueError.DataSourcePath: Servername
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error

Can someone help me to overcome from this issue?

Workspace is Power BI Premium 

Thanks,

Priyanga

[v-lili6-msft]

hi, @Anonymous 

If you could download the pbix file and try to refresh it in power bi desktop and see it could refresh well.

Best Regards,

Lin

[Anonymous]

Hi Lin,

After scheduled refresh is failed, I try to refresh On demand in power BI service itself. It will be successful most of the time. 

The problem is atleast once in a week it starts failing with the following error mesaage.

Thanks,

Priyanga