Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
When i load new tables or refresh my current tables i get the following error message "Request did not succeed: The request was interrupted because of timeout" (See picture below in Danish). This often happens after about 1 hour, but a few times it works.
I'm using Azure Table Storage databases and Azure SQL databases. The ones that are timing out are a Azure Table Storage databases.
I have tried following this guide: https://stackoverflow.com/questions/51718344/how-to-set-a-max-run-time-timeout-for-power-query, but it did not work.
And all other guides here seems to solve the problem for Power BI Service, but how do i fix this for Power BI Desktop?
Kind regards,
Junior-BI-assi
Hi @Anonymous ,
What did you do while transforming data in Query Editor? Please delete the steps firstly (with the condition that you add the CommandTimeout argument ) to check if it works fine . If it is caused by transforming, maybe you could implement it with DAX.
The steps are as follows (Exanding data and changing the type of a single collumn)
let
Kilde = AzureStorage.Tables("triggerevents"),
alleventsY2020M1 = Kilde{[Name="alleventsY2020M6"]}[Data],
#"Udvidet Content" = Table.ExpandRecordColumn(alleventsY2020M1, "Content", {"CustomerTriggerId", "Data", "EventDateUtc", "EventFound", "ResponseMessage", "Success", "TriggerName"}, {"Content.CustomerTriggerId", "Content.Data", "Content.EventDateUtc", "Content.EventFound", "Content.ResponseMessage", "Content.Success", "Content.TriggerName"}),
#"Ændret type" = Table.TransformColumnTypes(#"Udvidet Content",{{"Content.EventDateUtc", type date}})
in
#"Ændret type"
How do i add commandtimeout argument?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |