Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have created a Power BI dashboard using Power BI Desktop. The dashboard is using a dataset that comes from a SQL database. All the tables are imported to Power BI via Direct Query. Next, I publish the dashboard do myworkspace and I would like the dashboard to automatically refresh every time new data is added to the database or every minute for example.
At the moment I'm getting an error saying there is no gateway to acces the data source.
Could anyone please help me to set it up?
Thanks
Solved! Go to Solution.
Hi @LauraBueno
For any On-Premise source i.e. source not on cloud, we need to install GateWay for creating a connection through service. Please see below ref docs on further details.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
https://data-flair.training/blogs/power-bi-gateway/
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
Hi @LauraBueno
For any On-Premise source i.e. source not on cloud, we need to install GateWay for creating a connection through service. Please see below ref docs on further details.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
https://data-flair.training/blogs/power-bi-gateway/
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |