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 r...
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.

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity 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
      Icon for Community Support rankCommunity 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 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

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