How to scheduled refresh for a dataset which is having data from both normal and premium workspace ?

[Amar-Agnihotri]

I have a dataset published in service. The data is coming from two dataflows out of which, one is in the noirmal workspace and the otherone is in the premium workspace. I am trying top scheduled refresh the dataset but it is getting failed. dataset D is in the normal workspace but it is having tables from dataflow A and dataflow B . A is in the same normal workspace in which dataset is but B is in the premium workspace . Can anyone give a solution for this or this is some kind of  restriction in service? 

[Burningsuit · Accepted solution]

Hi @Amar-Agnihotri 

As far as I can tell, this is a licencing restriction. Dataflows on Premium workspaces cannot be used to populate Datasets on non-Premium workspaces. You'll have to move the Dataflow to non-Premium or the Dataset to Premium.

See: What licenses do you need to use dataflows - Power Query | Microsoft Docs

Hope this helps

Stuart

[Amar-Agnihotri]

Thanks  @Burningsuit 😊