Forum Discussion
Direct Query Report in Power BI Service Not Working with Error but Desktop Works?
Howdy folks, Been a while since I worked with PBI and am hitting a very odd issue. So we have an enterprise gateway where we set up a connection to a remote Azure MS SQL Database. We created...
Hi rodneyc8063
Can you confirm that you have got the latest version of the Gateway installed?
We have the "June 2024 update (3000.226.5)" installed currently.
One thing I did notice though is that for our gateway connection we were advised to check off "Skip Test Connection" as otherwise it would "always fail" as per our vendor.
Not sure if this may have an impact on Direct Query working or not since it seems with Import it works just fine. Its just when we try Direct Query we are hitting issues with this particular data source