Forum Discussion
'Unable to connect to data source undefined'
Trying to refresh a dataset from 3 different sources - two are databases within the same server and then one additional server. All have been set up with the gateway I'm using. I haven't seen the...
- Set Privacy Level to Organizational
- Made sure all reports are refreshed at different times
- Created another on-premise gateway to split the load
- Created database tables rather than views to reduce processing between PowerBI and MSSQL
- Ensured both desktop and gateway has the latest version installed at all times
Great list, Sonia!
After the June 2019 update...
* remove orphaned queries with old data sources even if they don’t in any way get loaded (always a good idea)
* make sure if hitting two databases that they use the same windows credentials.
* remove any queries that trigger the “”hand authored queries” warning
* remove orphaned queries with old data sources even if they don’t in any way get loaded (always a good idea)
* make sure if hitting two databases that they use the same windows credentials.
* remove any queries that trigger the “”hand authored queries” warning
Thanks freder1ck. I don't beleive that would have been the cause of the refresh because:
* I don't think we would have orphaned queries
* Most dashboards only use one database
* I have never seen this error: “”hand authored queries”However potentially this will work for other people.
In the end, we built a script and a lambda that refreshed each dashboard every morning rather than using scheduled refresh in powerbi. This script keeps trying to refresh until successful. Since building that script we do not often have to try more than once to refresh and have no errors.
