Scheduled Refresh not working with Smartsheet Connection (PBI Service)

[kentmiguel1]

Hello,

For one of my reports, I have sources from Oracle DB, Excel, and Smartsheet. It updates/refreshes perfectly in PBI Desktop but when I publish it to PBI Service it is showing me this error.

It was working before I added the Smartsheet connection.... 

[v-juanli-msft]

Hi @kentmiguel1 

The error message is not correct to show the real cause for the problem, it is a bug and MS are working on it.

Smartsheet is a online data source, so it can refresh on Power BI Service without gateway.

To make refresh on Power BI Service work for Smartsheet data, please go to: This dataset->Setting->Schedule refresh->Credential->table names(smartsheet data source) ->Please give correct crendetial as your desktop granted.

Oracle or Excel may be on local server, if so, they are on-premise data source, to make them refresh successfully on Power BI Service, please install a on-premise gateway(not personal), then add data source under the gateway.

For more details, please refer to:

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

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

To make online data and on-premise data work together and refresh successfuly, please refer to the following

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

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.

[v-juanli-msft]

Hi @kentmiguel1 

Currently, Power BI users using invalid credentials for refresh operation may see a message saying "The last refresh attempt failed because of an internal service error. This is usually a transient issue".

Please verify credentials are correct before retrying. Engineers are working to update the error classification and an ETA on a fix will be provided soon.

Also, select "Organizational" for Privacy level.

All data source needs to be added to the gateway if they are on-premise,

for online data source, it is no need to add it under data gateway, but you need to give correct credential under Schedule refresh setting.

For more detials: 

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

https://docs.microsoft.com/en-us/power-bi/service-gateway-enterprise-manage-sql

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

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.

[kentmiguel1]

Hello! I tried changing the "Privacy Level" but it is not working.. 😞

[edhans]

The privacy levels in the service need to match what you put in your Desktop, and as tempting as it is, telling the desktop to ignore privacy settings often causes issues in the service if there are multiple sources. Make sure you go through the settings in the desktop file, then ensure the Service is set to the same for each data source.

Also, ensure that your Oracle queries have a separate Source for each table. Don't create a query to the Oracle database, then create a reference to that and select a table, then repeat for each table. Each table has to have a Source going to the database, not another query, or it can cause issues when merging with other data sources.