cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
plillevold Frequent Visitor
Frequent Visitor

Slow performance when publishing reports to Power BI

We are experiencing very slow publish times when publishing reports to powerbi.com.

After one hour of "spinning wheel" in Power BI Desktop, it fails with a "Sorry, you don't have access to publish..." error.

 

Is this related to the performance issue in North Europe?

 

 

7 REPLIES 7
plillevold Frequent Visitor
Frequent Visitor

Re: Slow performance when publishing reports to Power BI

Here is the error message we receive:

 

image.png

 

 

 

Community Support Team
Community Support Team

Re: Slow performance when publishing reports to Power BI

Hi @plillevold ,

It will be help if you share some detail information.(e.g. data source type, records amount, column fields amount, connection mode, any advanced operations in query editor...)

Regards,
Xiaoxin Sheng

 

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
plillevold Frequent Visitor
Frequent Visitor

Re: Slow performance when publishing reports to Power BI

Hi @v-shex-msft ,

 

Data source is an Excel file (size ~30KB) stored in the dashboard, 10 columns. No advanced query operations.

So really a small and non-complicated dashboard Smiley Happy

plillevold Frequent Visitor
Frequent Visitor

Re: Slow performance when publishing reports to Power BI

Any feedback @v-shex-msft ?

Community Support Team
Community Support Team

Re: Slow performance when publishing reports to Power BI

Hi @plillevold ,

Is there any practical security settings enabled on that workspace?
Did this datasource stored on local or you are getting data from power bi service connector and from specific workspace?

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
plillevold Frequent Visitor
Frequent Visitor

Re: Slow performance when publishing reports to Power BI

Datasource (as mentioned, Excel) is a local file.

 

Security-wise, members can publish content to the workspace. 

Otherwise, the workspace is running on an A3 Premium instance.

 

What specifically do you mean by "practical security settings" ? 

 

Community Support Team
Community Support Team

Re: Slow performance when publishing reports to Power BI

Hi @plillevold ,

Has records stored in excel directly or it linked with an external data sources? In addition, I'd like to suggest you use fiddler to trace the publish steps to see if any policy block these requests.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |