PowerBI refresh dataset is failing.

[sabeer6870]

I cannot refresh the dataset in PowerBI on desktop but when I individually all queries work.

Each time one of the queries fails.

I have changed the timeout to very high time(even though I never got a timeout error). 

In my dataset, I have around 15 queries which query 4 different data sources.

Has anyone faced this issue? Is my number of queries are too mcuh?

On ex. error:

Query execution has resulted in error (0x800300FD): Partial query failure: An unexpected error occurred. (message: 'StorageException with HttpStatusCode 503 was thrown.: : 

[Christine218]

I am having issues as well.  I have my datasets on a Sharepoint set to auto refresh.  They haven't done that since the beginning of December.  The manual refreshes are not working either. 

[mwegener · Accepted solution]

Hi @sabeer6870 ,

I think it's due to the sources.

Possibly you could stage the data in data flows.

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[sabeer6870]

thanks for the reply @mwegener 

My query was partially failing in Kusto, fixed that