Power BI slow for external users

Hi , Anonymous 

According to my understanding of report presentation and interactive performance in Power BI, it is mainly based on three modules, one is the capacity of your report (shared or private), one is the performance of your report itself (including the complexity of data transformation and the amount of visuals), and the last is the performance of the data source (this problem is only for reports that use DQ or LC mode to connect directly to the data source), because for these datasets you need to send queries to the data source in real time. The speed of the data source response and query played a decisive role. According to your problem description, your internal users and external users are invited to your tenant, in the same capacity, and access the same report, then the first two points can be directly excluded, we focus on the third, you need to first confirm whether you are using a DQ or LC mode directly connected to the data source report, if so, may only narrow down the root cause of the problem to your data source. I think you can confirm if the AAS layer data source will recognize the user's AAD credentials and distinguish between external and internal users. Thank you so much!

This is another document about the troubleshooting flowchart of slow report loading, please check out:

Troubleshoot report performance in Power BI - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly