Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

'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...
Need Help
SoniaB102's avatar
SoniaB102
Advocate I
7 years ago

Also getting that error message, among others.  We have a multiple datasets refreshing daily and they fail for different reasons at different times.  We autorefresh datasets using an on-premise gateway. It has been going for over 6 months.  You may want to try all the things we have tried in case that helps:

 

  • 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

 

  • freder1ck's avatar
    freder1ck
    Kudo Kingpin
    7 years ago

     

    • 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!

     

     

     

    • freder1ck's avatar
      freder1ck
      Kudo Kingpin
      7 years ago
      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
      • SoniaB102's avatar
        SoniaB102
        Advocate I
        7 years ago

        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.