cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
marklovejoy Frequent Visitor
Frequent Visitor

Scheduled Refresh Works with personal Gateway but not with ON PRemise Gateway

Hello PBI Community,

 

I m trying to set-up schedule refresh with the Recommended Gateway from Microsoft.

 

I want to Schedule refresh some CSV and Excel file from a One drive folder.

 

It works well when I m using the Personal Gateway, but when I try to do it with the recommended on premise gateway it doens't work.  Showing this message:

 

Screen Shot 2019-02-20 at 14.46.16.png

 

Access Unauthorized: How is this possible? I have permission to access and modify the One Drive folder, I did the set-up for the Gate way, basically I m the owner of everything except the Office 365 licence management which belongs to our IT team.

 

All of this is really workign well with perosnal gateway, so I don't understand why it won't work for On premise Gateway?

 

Any Ideas :-) ?

 

Regards

 

Mark Lovejoy

4 REPLIES 4
Community Support Team
Community Support Team

Re: Scheduled Refresh Works with personal Gateway but not with ON PRemise Gateway

Hi @marklovejoy 

Do you add "CSV and Excel file" as a data source under the on-premise gateway and give the correct credentials?

3.png

 

Reference:

manage a gateway

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

marklovejoy Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh Works with personal Gateway but not with ON PRemise Gateway

Hello,

 

but which are the credentials? My personal office 365 account? Or the IT departement credentials?

 

Knowing that I m the one who created everything. (PBI file, Gate way, One drive is under my crendentials,...) Juste the office 365 licensing is handled by IT.

 

Mark

Community Support Team
Community Support Team

Re: Scheduled Refresh Works with personal Gateway but not with ON PRemise Gateway

Hi @marklovejoy 

Do you select Allow user's cloud data sources to refresh through this gateway cluster > Apply under Gateway Cluster Settings?

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

 

When you enable the function above, then after publishing to service, go to the setting->refresh under the dataset, supply the credentials used to connect to the back end data source.

https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

 

Best Regards

Maggie

Community Support Team
Community Support Team

Re: Scheduled Refresh Works with personal Gateway but not with ON PRemise Gateway

Hi @marklovejoy 

Since the datasource is stored in OneDrive, so the account of OneDrive and Power BI should be the same one, the credential put in the dataseting is alos the same one.

 

Best Regards

Maggie