Forum Discussion

matthewt's avatar
matthewt
Frequent Visitor
8 years ago
Solved

Cannot Get Data from Data Gateway

Hi There   I've been testing connecting PowerBI to our company database and have created a local copy of the Postgre SQL database on my wokstation. I've then installed the PowerBI gateway successf...
Need Help
  • matthewt's avatar
    matthewt
    8 years ago

    So. Solution.
    (Kinda)

     

    When performing the tests locally, I was able to publish the reports to powerBI.
    When impoted, it created a dataset, and from there, I was able to actually set it to automatically refresh and point it at a data gateway.

    Upon the refresh, it successfully pulled from the database.

     

    So, rather than importing the data directly via the gateway.

    Create the report locally, connecting to the SQL database.

    Publishing that report with its dataset to PowerBI online.

    Opening the dataset imported during the publishing.

    Going to its settings.
    Selecting automatic refresh.

    Selecting my data gateway.

     

    Whew.

matthewt's avatar
matthewt
Frequent Visitor
8 years ago

Hi Ross

 

Thanks for the reply.

I'm not having an issue with the connection to the database, it's using the data.

 

 

I used localhost as the server address but the issue remains ad the connection is fine regardless of that being localhost, 127.0.0.1, or my address on the local network.

 

From this point, I'd hypothetically go to "create report" or "create dataset" however I'm unable to add the data.

 

I'm not sure how the addresses you've mentioned could affect this, only the server name makes sense to me. 
I'm guessing we've misinterpreted eachother.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Does your file have any other data sources?  This can also cause an issue as the gateway is a jealous type and its either an all or nothing deal.

  • matthewt's avatar
    matthewt
    Frequent Visitor
    8 years ago

    Nope.

    The only connection to the database is through the gateway, and the admin panel anyway.

    PowerBI Online is pretty much empty as this is the first attempt at using it.
    It's a very boring and fresh setup soley to test whether it works.

     

    From what I can gather, the next step would be going to "Get Data", "Databases", SQL Server Analysis Services", which would have the gateway appear.

    I get the below though.

     

     

    There's no issues using the local PowerBI app connecting directly to the database either. But online just seems to go nowhere.

    • matthewt's avatar
      matthewt
      Frequent Visitor
      8 years ago

      So. Solution.
      (Kinda)

       

      When performing the tests locally, I was able to publish the reports to powerBI.
      When impoted, it created a dataset, and from there, I was able to actually set it to automatically refresh and point it at a data gateway.

      Upon the refresh, it successfully pulled from the database.

       

      So, rather than importing the data directly via the gateway.

      Create the report locally, connecting to the SQL database.

      Publishing that report with its dataset to PowerBI online.

      Opening the dataset imported during the publishing.

      Going to its settings.
      Selecting automatic refresh.

      Selecting my data gateway.

       

      Whew.