Datasource and Scheduled Refresh Greyed Out

[Anonymous]

Hello,

we have a PBI Model in import Mode that is ~350 mb big.

When we upload it to the PBIRs we can not set the Datasouce and thus not create a scheduled refresh.

We use SQL Code (source is a MSSQL Server Databsae) to get the data and if we filter it to make the Dataset smaller (e.g. 60mb), everthing works as expected.

Does PBIRS have a limit when refreshing data by schedule?

Best Regards

[Anonymous]

@Anonymous 
Try this solution from other post for data source grey out. 
Solved: Data Source Connection Settings are Greyed Out in ... - Microsoft Power BI Community

Regarding to schedule refresh, please check whether you have met one of the limitations:

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.