Updating wont work in app.powerbi

[Anonymous]

Hello guys,

I created a power bi file with power bi desktop. Its very big and has many imported sources. In power bi desktop the refreshing needs about 15-20min - sometimes more.

Now I uploaded it to app.powerbi choose all the right login informations and try to refresh it.

It needs there forever and after a period of time (like an hour) it says it "timed out".

What else can I do besides to try to downsize the file?

Thanks

[Anonymous]

@selimovd 

thank you.

But where can I find this data source dialog for the server?

[selimovd]

Hey @Anonymous ,

depends if you only have one table from this database or multiple tables from this database.

In both cases go to Power Query first.

If you have multiple tables from the same database do it via the data source settings. Select the "data source settings", select the SQL Server and click "Change Source". In the next dialog you can change the timeout. This changes it for all tables from this data sources:

If you just want to change it for one table, you can do it directly in the query:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[selimovd]

Hey @Anonymous ,

what is the data source? Is it SQL Server, is it OData, is it an Excel file? For some data sources you can change the duration before timeout, for some data sources you can change the performance of the underlying source, for example by adding an index, some you can scale up.

Is the data source on premises with a gateway or in the cloud?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

I got 2 sources. One is a Excel file in the cloud and one is a table from an SQL Server.

Where do I find the options for the timout and the performance you mentioned.

[selimovd · Accepted solution]

Hey @Anonymous ,

the SQL server you can change the timeout in the data source dialog:

This will then be translated to the "CommandTimeout" parameter with the #duration function:

The timeout can also be added to.

WebPages:

= Web.Page(Web.Contents("URL", [Timeout=#duration(0, 1, 0, 0)]))

Or OData Feeds:

= OData.Feed("http://myUrl.com/service.svc/", null, [Timeout=#duration(0, 1, 0, 0)])

Maybe that solves already your problem.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

@selimovd

I got 2 sources. One is a Excel file in the cloud and one is a table from an SQL Server.

Where do I find the options for the timout and the performance you mentioned.