Update Dataset without installing Gateway

PowerBIGpig · ‎08-20-2020

Hello!

I am under some strict conditions for using PowerBI, and installing the Gateway will not be done without a committee, multiple sacrifices and a sizeable down payment to the IT gods.

With that in mind, is there a way to update PowerBI Pro Dataset (which was uploaded from PowerBI Desktop) without the Gateway?

collinq · ‎08-25-2020

Hi @PowerBIGpig ,

ALong with @lkalawski answer, you could do a personal gateway. (Assuming that the IT Gods will turn a blind eye to such things and not require too much of a sacrifice.) This means that you would have to keep your computer "on" during those refresh times that you set, but that is probably about it.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.

lkalawski · ‎08-20-2020

Hi @PowerBIGpig ,

If the data is on-premise server, there is no other way to refresh the data in Power BI Service. A gateway must exist for the data refresh request to succeed.

In this case, there are two solutions:
1. Install the gateway to connect to the database.
2. Transfer data to the cloud, then the gateway will not be needed.
_______________
If I helped, please accept the solution and give kudos! 😀