Forum Discussion

ramu4000's avatar
ramu4000
Frequent Visitor
10 years ago
Solved

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

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 a...
Need Help
  • ramu4000's avatar
    ramu4000
    10 years ago

    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's avatar
cosborn1231
Icon for Resolver I rankResolver I
10 years ago

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's avatar
    ramu4000
    Frequent Visitor
    10 years ago

    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