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 

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