Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

synchronization time with directquery

Hello, Thank you for reading my post, I'm not a PowerBi regular user. My collaborator has a synchronization problem with DirectQuery, either on PowerBi Desktop or on PowerBi online with the on-prem...
  • collinq's avatar
    5 years ago

    Hi Anonymous ,

     

    This is an issue with potential many different areas of concern.  Since you mentioned  VPN I would be considered first about network speed.  Some organizations have their VPN significantly throttled - even though your PC's speed and network connections are great, the VPN is not.  I would suggest a network trace (like using Fiddler) and seeing what bottlenecks appear.  

    After network, there are potential issues within your queries themselves - you can use the Performance Analyzer on that.  Or, it could be your data source itself - is that allowing for reports to be run efficiently.  

    Again, I would suggest that you start with the network (ports, firewalls, anti-virus programs, security settings, etc. etc.)