How to Refresh Your Power BI Report with On-Premises Data

[ramu4000]

Hi,

 I got 2 reports from my collegue, both using same oracle datasources. 1st report when I import or open in Power BI desktop and publish, i can see the report in Power BI service webpage and also can Schedule Refresh the report using "Use a data gateway".

But the 2nd report after I publish same way from Power BI desktop, i can see "Use a data gateway" option disabled only Personal gateway enabled. I am unable to do schedule refresh with On Premises gateway. 

Can someone help me how to enable "Use a data gateway" option ?  and why for 1 report it is showing and another it doesn't any reason ?

Thanks and Regards,

Ram

[cosborn1231]

Hi @ramu4000,

For clarity here, is the 2nd report using a different underlying data source(s)?

If so: the Data Gateway Admin needs to register those data sources used within the 2nd report  (if they are on premises data sources) to do this under settings< Gateway click the Manage Gateway hyperlink.

The account associated with the gateway also will need to have the correct permissions to query the underlying data sources you are using. Once these sources are added and permissioned correctly your gateway should be able to be leveraged.

I have a blog on this as well:

http://www.businessintelligencebuilder.com/#!Power-BI-Gateways/c21xo/57858f6a0cf25aa82d55635c

Good luck, I hope this helps!

[ramu4000 · Accepted solution]

Wow thats great, it solved my problem.

Actually my 2nd report has 3 datasources, 2 are from web, 1 sharing same datasouce as 1st report.

After reading your article created 2 web datasources and tried schdule refresh with on premises gateway it workks.

thanks,

Ram

[cosborn1231]

@ramu4000

Awesome!