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 

Matt22365's avatar
Matt22365
Resolver III
7 years ago

Hi

Thanks for getting back to me

All the people who would need to refresh are on the workspace as owners. All the data is stored on the companies sharepoint which all users have access to.

 

I am new to Gateways, however as all the data is stored on sharepoint I am not too sure why it is needed

 

Thanks

 

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