Forum Discussion
Scheduled Refresh not working with Smartsheet Connection (PBI Service)
Community SupportHi 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.
Hello! I tried changing the "Privacy Level" but it is not working.. 😞
- edhans
Community Champion
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.
