Report could be refresh but not on PowerBI.com

[lbsong]

I have a PowerBi report, which could be refreshed on PowerBi desktop, but couldn't on PowerBI.com, and could not schedule refresh the dataset. The information message is: 

You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

[v-caliao-msft]

@lbsong,

You can't schedule refresh for this dataset because one or more sources currently don't support refresh.

Based on this error message, it seem that you have multiple data source on your report. can you check it? If you have multiple data source on your report, you need configure gateway for each of them.

In order to check if you can sechdule refresh your Azure data source, please create a simple report which only contain Azure data source. 

Regards,

Charlie Liao

[lbsong]

Thank you @v-caliao-msft, I double checked the data source. There is only one data source which is Azure DB. 

In any case, it has no any issue when refreshing in PowerBI desktop. I think it should behave same on PowerBI.com. 

[Seth_C_Bauer]

@lbsong Did you follow all the criteria from this article? Particularly the "Allow access to Azure Services"?

[lbsong]

@Seth_C_Bauer, I don't think it's the problem here because the refresh works very well in PowerBI Desktop. It does not refresh only on PowerBI.com. 

And my other reports refresh correctly which uses the same database. 

[Seth_C_Bauer]

@lbsong Ok, You are positive that the only data source you have in the report is the Azure SQL DB? Or is there "any" other data source you have in the file as well? This error is usually pretty accurate and it revolves around multiple data sources that don't work unless you have a personal gateway in the Service due to the mixing.

[Seth_C_Bauer]

@lbsong What are the data sources, and what gateway are you trying to use?

[lbsong]

Thanks for replying, @Seth_C_Bauer. The data source is SQL DB on Azure. I don't have a gateway for my reports, and I have other reports which work well without gateway.