Forum Discussion
Cannot Get Data from Data Gateway
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.
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.
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.