Forum Discussion
Error trying to refresh report in PBI Service
Trying to avoid the need for a gateway, I moved my Excel file into a folder in SharePoint Online. My account has access to the SPO site and is able to open and edit the Excel data source. The Excel...
Hi v-kaiyue-msft,
Thank you for the response. I am signed-in to the same account for all these activities.
In the semantic model, I went to the Settings screen and noticed that "Data source credentials" is greyed-out.
It seems that--with the timings and expiractions and such that this action (refresh) is subjected to--perhaps a Gateway is still going to be required. Would I be correct that a Gateway would solve these problems in that it would maintain a constant connection with the data source?
(I think I have a lot more homework to do!)
lbendlin
Super User
Super UserSharePoint Online does not require a gateway. Your semantic model must contain other , on-premise data sources that do require a gateway.
In Power BI Desktop check "Data Source Settings"