Forum Discussion

Matt22365's avatar
Matt22365
Resolver III
7 years ago
Solved

Gateway issue

Hi I hope someone can help I have a BI report currently on My workspace which pulls data from multiple places . Now the report has finished its built I need everyone with access to be able to refre...
Need Help
  • Matt22365's avatar
    Matt22365
    7 years ago

    Hi

     

    Thanks for geting back to me. Some of my data is in sharepoint files, sharepoint task list and MS Project Online files.

     

    However I found the issue, one of the tables I created to bridge the relationship between other tables was stored on my desktop rather than sharepoint. Once I moved this, the schedule refresh updated without a gateway.

     

    Interesting point on hourly updates, I was not aware it did this, something to look into.

     

    Thanks for your help

     

    Matt 

deepu299's avatar
deepu299
Advocate V
7 years ago

Matt22365  If the data is on sharepoint, since Power BI and Sharepoint are part of same O365 suite, you will not need a gateway. 

In this document, it was mentioned to schedule a refresh but I think when the data is changed on sharepoint it will reflect on Power BI within 1 hour. You have mentioend that the dataset has multiple sources, what are other sources?  

Matt22365's avatar
Matt22365
Resolver III
7 years ago

Hi

 

Thanks for geting back to me. Some of my data is in sharepoint files, sharepoint task list and MS Project Online files.

 

However I found the issue, one of the tables I created to bridge the relationship between other tables was stored on my desktop rather than sharepoint. Once I moved this, the schedule refresh updated without a gateway.

 

Interesting point on hourly updates, I was not aware it did this, something to look into.

 

Thanks for your help

 

Matt