Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Data sources don't support refresh

I have a power bi project that I made in the desktop application. I am able to upload it and edit it in the web version, but I can't schedule refresh because i get the message:

You can't schedule refresh for this dataset because one or more sources currently don't support refresh.
 
I really need it to automatically refresh.
 
My sources are 3 MySQL databases, an excel spreadsheet, Google Analytics, Google Big Query, and Salesforce.
 
I've used Salesforce, the spreadsheet, and the database conections in other reports where I have been able to schedule refresh just fine. I am able to refresh manually without an issue, though I do not need all of my data to refresh every time so I have set some of them to not include in report refresh. I hope that that is not the issue.
 
What is making my data not able to refresh automatically?
 
 
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi Anonymous,

     

    Based on my test in Power BI desktop 2.51.4885.701 64-bit (October 2017), get data from MySQL database,local Excel file,Google Analytics,Google Bigquery, Salesforce data sources then publish to Power BI service, there are options for us to enter crednetial for data sources and set schedule refresh. 

     

     

     

     

    In your scenario, please open Data source Settings in Power BI desktop to verify if only these five data sources used. 

     

     

    Also please check if you just retrieved data, do you do any steps in Query Editor, eg: Append Queries, Merge Queries? Please try to run the same desktop version as ours. 

     

    Best Regards,
    Qiuyun Yu 

     

     

  • Anonymous's avatar
    Anonymous
    8 years ago

    Google Bigquery connector must have gotten refresh support in last update.

7 Replies

  • dzungnguyen's avatar
    dzungnguyen
    Frequent Visitor
    7 years ago

    Anyone knows this problem, I am fetching data from Jira query, it works normally in PBI Desktop

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Try disabling refresh in your Query Editor for those queries you don't need to refresh. Otherwise, the Power BI service is going to complain about not being able to fetch new data, due to a potential lack of an appropriate datasource.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      That is how I disabled them.

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    8 years ago

    Hi Anonymous,

     

    Please enable the "Include in report refresh" for all tables in Power BI desktop then republish to service. Go to Dataset Settings, check which gateway you use, on-premise data gateway (personal mode) or on-premise data gateway. Please share the screenshot of the dataset settings here like below screenshot. 

     

     

    Best Regards,
    Qiuyun Yu 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I enabled "include in report refresh" and republished.

      My Dataset settings for the project still looks like this:

       

      *edit* Anyways I would be using a personal gateway.

       

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        8 years ago

        Hi Anonymous,

         

        Based on my test in Power BI desktop 2.51.4885.701 64-bit (October 2017), get data from MySQL database,local Excel file,Google Analytics,Google Bigquery, Salesforce data sources then publish to Power BI service, there are options for us to enter crednetial for data sources and set schedule refresh. 

         

         

         

         

        In your scenario, please open Data source Settings in Power BI desktop to verify if only these five data sources used. 

         

         

        Also please check if you just retrieved data, do you do any steps in Query Editor, eg: Append Queries, Merge Queries? Please try to run the same desktop version as ours. 

         

        Best Regards,
        Qiuyun Yu