can't schedule refresh for the dataset

[Anonymous]

Hello,

I have prepared the dataset in Powerbi. The data comes from SharePoint and holebase(SQL database). I have merged them and then published.

However, can not schedule a refresh.

Could you please assist with this regard?

[Anonymous]

Could it be the problem that, the source is marked as "Table"? The reason why it is a table is that the query is the end result of merged tables from different source

[Anonymous]

Thanks for youre reply.

The error is:

"You can't schedule refresh for this dataset because the following data sources currently don't support refresh:"

[Pragati11]

HI @Anonymous ,

What is the source of your data?

There are certain data-sources in Power BI that don't support Schedule refreshes.

Check the following link with the list of data-sources that support Schedule Refresh in Power BI Service:

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

[Anonymous]

Hello ,

Thanks for your comment.

the sources are "SQL server" and "SharePoint", so it should be okay. For being sure, I have tested to publish them separately and try to refresh the data.

With SharePoint one, it went okay.

However, with SQL server, it gives the following error:

[Pragati11 · Accepted solution]

HI @Anonymous ,

You will need a Gateway to refresh data coming from SQL Server.

Check the link that I shared earlier on Data refreshes in Power BI.

[Anonymous]

Thanks a lot. It worked!

[Pragati11]

HI @Anonymous ,

When you say you cannot schedule refresh for the dataset; what do you mean by this?

Are you getting any error while scheduling refresh? Can you kindly add more details here?

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

It is another attached screen of the error that I get.

Thanks in advance for the assistance!