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 All
Is there are anyway to automatic refresh in power bi without gateway. Actually I want to say If My computer is in switch off mode and I have scheduled my refresh at night 11 PM then it has to be run and change the dashboard.
Regards,
Arvind
Solved! Go to Solution.
It will do yes, as long as you have set up the schedule.
Heres a great article on the topic: https://ruiromanoblog.wordpress.com/2018/02/01/convert-a-power-bi-desktop-report-from-import-to-live...
It's kind of a trick, but much better than copying every single query over to a new file.
This chrome extension did trick for us.
https://spgaurav.blogspot.com/2019/04/chrome-plugin-to-auto-refresh-power-bi.html
Note : This wont work with full sceen
I have a SFDC report and an excel report, where power bi is pulling the report. Is that also possible?
What steps should I take?
Hi @arvindyadav
If your data is stroed on the cloud you will then not need the Gateway to refresh the data.
But if your data is stored on premise then you would need either the On-Premise Gateway or the Personal Gateway.
Hi @GilbertQ,
I am using Azure sql database . If I am using Azure sql database then there is no need of gateway am correct?
Regards,
Arvind
Yes no need to connect gateway's.
Even we are also using AZURE SQL Servers with out Gateway our projects are working fine.
Regards,
Bajee.
Hi,
What about if its a SQL warehous ebut not Azure?
I have a SQL warehous eon the cloud but its still asking meto use a gateway for it
Is Azure warehouses the only ones supported?
Thx,
Ricardo Brubaker
Hi @GilbertQ,
Okay Cool.
But when I Edit Credential in power bi service for scedule regresh it gives me pop up message which you can find in below image.
Regards,
Arvind
Yes you still need to provide the details of the azure server as well as log in details so that it can be used as part of the refresh.
Hi @GilbertQ,
I have connected with Azure Sql database successfully now ... So My data will also refresh when I offline?
It will do yes, as long as you have set up the schedule.
Okay Cool let me check.
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 |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |