Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Dataset not automatically refreshing

My automatic refresh for my dataset on Power BI app has not been working. The dataset is connected to 2 SQL servers and I have confirmed connection with them.

 

  1. I have clicked on the refresh option on my dataset 
  2. I have checked my on-premise gateway connection to confrim all ports are successfully opened.
  3. I have removed the refresh requirements for unecessary queries by right clicking in the power query editor and deselecting 'include in refresh report' from a query. 
  4. I have confirmed connection with the SQL servers in the app and desktop report as well. 
  5. I have completed a scheduled refresh, it failed.

After all the above methods I continue to get these errors.

 

 

How do I fix the Automatic refresh for my reporting?

 

 

Need Help

4 Replies

  • gauthamboppana's avatar
    gauthamboppana
    Solution Specialist
    4 years ago

    Anonymous  - Please try the below steps. Let me know if it works.

    1)  Download the report and doing a full refresh in PowerBI desktop. Then re-publish to the Power BI Service.

    2) Now go to the dataset settings and  click on edit credentials. Re-enter the credentials and refresh.

    Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

    Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

    Thank you very much !

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you for your reply! I have done what you suggested but it still is having a refresh error!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        I am thinking it's a Power BI Service privacy issue with the datasets. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

     

    This happens when the data source you used, within Power BI Desktop, isn’t supported for refresh. You will need to find the data source that you are using and compare that against the list of supported data sources at Refresh data in Power BI.

    https://docs.microsoft.com/en-us/power-bi/connect-data/service-admin-troubleshoot-unsupported-data-source-for-refresh .

    Please also take a look at this topic:

    https://community.powerbi.com/t5/Service/You-can-t-schedule-refresh-for-this-dataset-because-one-or-more/m-p/335764 .

    Custom functions and query parameter not support in power bi service. If your source table contains above features, you can't enable refresh features on power bi service.

     

    Best Regards,

    Jay