Gateway issue

[Matt22365]

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 refresh the dataset.

I moved the report to a shared workspace, however my schedulled refresh has stopped working and no-one can manually refresh the data. The error is due to a gateway not being set up.

I am not sure how to do this and whether each user needs to set up a gateway

Thanks for your help

Matt

[deepu299]

@Matt22365 

Hi Matt, more details are needed to answer your question. 

Only users who are on the workspace will be able to refresh the dataset. Are they all added to the shared workspace? Are they part of the data source within gateway, they need to be added under users tab. 

There is no need for each user to setup the gateway if you are talking about on-premise enterprise gateway. See the difference between enterprise and personal mode:  https://docs.microsoft.com/en-us/power-bi/service-gateway-personal-mode

[Matt22365]

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]

@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 · Accepted solution]

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