Unable to Schedule Refresh for Chained Dataset

[willayd]

I have created a "chained dataset" using DirectQuery for Datasets as described here:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

As part of chaining I am adding two excel files hosted on Sharepoint. When I posted the new dataset to the service the option to Schedule Refresh of the dataset is grayed out - any idea why this may be occurring?

[willayd]

The excel files are hosted on Sharepoint. I don't think is the issue as everything works fine and is refreshable when using a normal dataset.  The issue seems specific to chained datasets

[v-deddai1-msft]

Hi @willayd ,

Have you configure all credentials for power bi dataset and sharepoint files well? It works well based on my test:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[willayd]

Hmm thanks for sharing. The credentials are set correctly as I can refresh manually. The one difference between my setup and yours based off of the screenshot is that my dataset is using the Web connector instead of sharepoint.

[willayd]

Unforunately I've tried using a sharepoint connection instead of web but still hit the same limitation.  The dataset continues to work and can be refreshed manually but the scheduled option is still grayed out

[v-deddai1-msft]

Hi @willayd ，

I can't reproduce your issue. Would you please try to just contains one dataset connection in the new dataset to see if the scheduled refresh worked. If the issue is still existing, please go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[GilbertQ]

Hi @willayd 

As far as I understand you would be able to do this on your dataset where the excel files are hosted.

Also depending on where the excel files are hosted you might need to have the gateway installed.