Dataflow refresh failed - only 150k lines and 4 columns [On-Prem]

[ryszardre]

Hello, 

I have an issue with dataflow refresh - it excedess 2 hours limit and return an error. It is fact table with multiple  columns but I use Odata filter - first I select 4 columns, then filter lines by entry no:

Only one succesfull refresh occured on Sunday - is it because of Power BI Service  or On-Prem server performance issue?

[v-easonf-msft]

Hi, @ryszardre 

Is this a temporary problem? You may need to check the refresh failure history.

Please refer to the following document about refresh timeout to see if it helps you.

Understanding and optimizing dataflows refresh

Best Regards,
Community Support Team _ Eason

[collinq]

Hi @ryszardre ,

When you look at the refreshing error in the Dataflow refresh history, there should be a message explaining what went wrong.  If it is the two hour limit issue, can you refresh it faster in Desktop?  If you can refresh it faster in Desktop, and you don't see an error in the Refresh History, then you should probably open a ticket with Microsoft about the Dataflow failure.