Forum Discussion
AdministratorSlowness in Updating Data
Buen Dia, I wanted to consult what possible solutions or controls should be carried out to avoid the time of updating a report that is connected to SQL Server, the same for update that is made takes an estimated time of 3 or 4 hours, of course thank you very much.-
Hi Syndicate_Admin ,
As far as I know, Power BI support us to use Import or Direct Query connection mode to connect to SQL Server.
I think you need to optmize Power BI Performance, this is based on your connection mode.
Import:
Data reduction techniques for Import modeling
DirectQuery:
DirectQuery model guidance in Power BI Desktop
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Syndicate_Admin ,
As far as I know, Power BI support us to use Import or Direct Query connection mode to connect to SQL Server.
I think you need to optmize Power BI Performance, this is based on your connection mode.
Import:
Data reduction techniques for Import modeling
DirectQuery:
DirectQuery model guidance in Power BI Desktop
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.