Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
marlan84
New Member

Reload dataset through on-prem gateway or other way?

My issue is that I need to connect to a non-public API to fetch data. We cannot whitelist all of PowerBI/Azure/MS ip-ranges so we have whitelisted the PowerBI Gateway IP. This means that when I reload the PowerBI report on the server it works but when I publish it to the web I cannot reload it anymore since connection request comes from PowerBI web.

 

Is there a way of sending request for this specific report/dataset thorugh the gateway and therefor come from a whitelisted IP?
Is there a way of scheduling reload on the on-prem server and publish the dataset by using e.g. powershell and/or a scheduled task?

Is there another way of getting around this issue?

 

Thanks!

1 REPLY 1
amitchandak
Super User
Super User

@marlan84 , if you are able to refresh on your desktop, then you should be able to schedule a refresh using an on-premise gateway

 

Power BI Install On-Premise Gateway and configure it on service: https://youtu.be/lObMRofpbQ8

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.