Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Query change keeps spinning on OK button.

I have a couple of oracle sql queries that I have been using without too much trouble.   But, when I go make a change, it's been taking longer and longer to come back from the Power Query.    I've tr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I reworked the queries and it helped a lot

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 

 

AnushaSri AbhinavJoshi Thank you for your reply!

Please allow me to provide some other insights:

  1. OLEDB Connector Settings: Ensure that you're using the latest version of the Microsoft OLE DB Driver for SQL Server, as it's crucial for optimal performance and compatibility. You can download the latest version from here: Microsoft OLE DB Driver for SQL Server - OLE DB Driver for SQL Server | Microsoft Learn.

  2. Network and Database Performance: Sometimes, the issue might not be with the query or Power BI itself but with the network or the database server's performance. If possible, check the database server's load and ensure there's no network bottleneck affecting the data transfer.

 

 

 

Best Regards,

Jayleny

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    I reworked the queries and it helped a lot