In PowerBI refresh succeeding on PowerBI desktop, but failing when refreshing on the webpage

1
votes

I created a report in Powerbi desktop. The dataset is a view from a table and I used the Import method and not DirectQuery. There is a lot of data. So when I do a refresh on the PowerBi desktop, it does the refresh but takes a while. When I published my report, and scheduled a daily refresh, the daily refresh fails with the following error

Data source type: SQL 
Data source error: Microsoft SQL: Query timeout expired

How can I olve this. I have tried deleting and publishing the report again and again. I also checked the data credentials field in the schedule refresh tab.

1
powerbi
Direct Query wouldn't work for me because it doesn't support a lot of modeling. Also I do not want the database to be pinged everytime the report is used. – Aparna
Please define "a lot of data" - # rows, also size in MB of PBI Desktop file. – Mike Honey
The size of the Desktop PBI report is 85,417k. – Aparna
The size of the Desktop PBI report is 85,417k and the number of rows are 9428542 – Aparna

1 Answers

1
votes

I would open the report file in Power BI Desktop and make these changes:

  • Navigate to the "file" menu (top-left) / Options and settings / Settings
    • Under Current File / Data Load / Parallel Loading ..., check the Enable parallel loading ... option
    • Under Current File / Privacy, choose Ignore the Privacy Levels ...

Hopefully that's enough to get you over the line.

If not then I would work on speeding the query design. From your error message it sounds like the generated query is very slow to start returning rows. I'd try to move any Filter, Group By or Choose/Remove Column steps up the Applied Steps list so they have an impact early and reduce the load on your database server.