Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Unable to setup scheduled refresh for supported data sources

Hi, Since yesterday I'm unable to setup scheduled refreshes for new (supported data source) content - in this case an Excel report using Power Query to access an MS/SQL database:   You can't sched...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous 

Did you use import connection mode to build your report?

 

Personal Gateway only support import connection mode. 

 

Could other reports scheduled refreshed successfully?

 

Try to refresh your report in your desktop.

 

If refresh failed in desktop, please check your datasource in Data Source Setting.

Troubleshooting: Troubleshooting unsupported data source for refresh

 

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 latest desktop version. 

 

If refresh succeed in desktop, please try Enterprise gateway and it is better to install your gateway in the same PC with your data source.

 

Personal Gateway and Enterprise gateway:On-premises data gateway vs. on-premises data gateway (personal mode)

I found a post with the issue like yours: Data sources don't support refresh

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Just as an update, I created the equivalent report, using exactly the same data source (Import mode) in Power BI Desktop and was able to setup refresh OK, so problem seems to be specific to Excel?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi Anonymous 

      Could you configure schedule refresh successfully when you publish the equivalent report to Service, using exactly the same data source?

      Try to republish the report to service again.

      Is this report get data source from MS/SQL database and Excel?

      I found a post with the issue like yours: Data sources don't support refresh

       

      Best Regards,

      Rico Zhou

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Anonymous 

        Yes, that's correct. I Basically copied the existing M code from the Excel-based report (which doesn't work) and pasted it into the Advanced Editor in PBI Desktop, then created a simple table visual of the data from this. I published the PBIX file to the PBI Service and was able to schedule refresh no problem. The reason I'm using Excel is that the report is a Pivot table which works best for what I need to do - it is only getting data from a standard MS/SQL View, no other sources:

         

        Source = Sql.Databases("itl-tascsdb01\itl_tascs"),
        WAREHOUSE = Source{[Name="WAREHOUSE"]}[Data],
        WH_v_GetContractBookStockForDashboard = WAREHOUSE{[Schema="WH",Item="v_GetContractBookStockForDashboard"]}[Data],

         

        I'm now waiting on Microsoft 3rd-level support to call me back.

         

        Thanks

        John