Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Postgres DirectQuery "Requires Data Gateway"

I have recently moved from importing a ton of CSV's to DirectQuery on a Postgres SQL DB hosted on an Azure Server with Doctrine managing the mapping and OpenVPN restricting access (this is most likel...
  • edhans's avatar
    edhans
    6 years ago

    Yes Anonymous - if you have data that requires the gateway, like the CSV files, then it can make the issue more complex. 

    Can you get it working if you remove everything but the Postgre data? Just whack all of that other stuff and save as a new file. Then add data sources back until you hit the one causing the issue. You didn't say where your CSVs were. A gateway is needed for local/network files or SharePoint On Prem. Should not be needed for SharePoint online, Data Lake, and other online resources.

     

    But mixing and matching can still cause issues that are frustrating to trouble shoot. That is why I suggest do 1 data source, then add until it breaks and fix the breaks one at a time. 

    Given the error you have, something in your report thinks it needs a gateway to access the "data source file"