Issue with Schedule refresh in Power BI Service

[vnkesa123]

Hi,

I have created a report and published in Power BI service. And set up the schedule refresh. But it is failed with below error.

The dataset size is  64 MB only.

Can any one please help me how to resolve this? It is urgent.

Regards,

Naresh Kumar

[v-yetao1-msft]

Hi @vnkesa123 

You may need to optimize your data model for faster data refresh . The following articles are about data model optimization, you can refer to the following .

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance

https://docs.microsoft.com/en-us/power-bi/guidance/composite-model-guidance

Best Regards

Community Support Team _ Ailsa Tao

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

[hrishi]

I am not sure why this would happen but i would definitely check all my transformation steps applied to the data in power query.
are you merging any tables together ?