How to ignore excel file from schedule refresh in power bi service

[jay_patel]

Hello All,

I have a pbix having multiple datasets and the schedule refresh is enabled but it's not refreshing, as it's having a excel and the path is from my Local PC. as well as to avoid it from getting refreshed in power bi service I have disabled by unchecking to 'Include in report refresh' but when it goes to power bi service and i am trying to refresh the report manually , it's giving error like.

Scheduled refresh is disabled because at least one data source is missing credentials. 

Thanks in advance.

[v-eqin-msft]

Hi @jay_patel ,

Any updates? Could you tell me if your problem has been solved by @PC2790 's suggestion?

Best Regards,
Eyelyn Qin

[PC2790]

You need to provide the credentials for the dataset.

See related threads:

Solved: Data Source Credentials - not being able to enter - Microsoft Power BI Community

Solved: Data Source Credentials - not being able to enter - Microsoft Power BI Community

See if they turn out to be helful

[amitchandak]

@jay_patel , In the setting, there is an option for datasource setting. Please open that and edit credentials and check

[jay_patel]

Changed permission level to public in pbix and then published it to power bi services.
Than also it's giving error in gateway credentials.

[PC2790]

Try making the Privacy level for all sources as one. it should not be different for different for different sources.

It worked out for me when I made the Privacy Level consistent across all the sources