Forum Discussion
Dataset needs gateway
Ok, now it's making sense. It's a composite model. PowerBi Dataset B + other sources. Are those other sources connected with a gateway? There is an option when using a gateway to allow the dataset use cloud and onpremise sources without requiring a gateway. That one can make conflict if it's not checked.
I hope that helps,
Hi!
Thank you for your response!
After checking an option of allowing user's cloud data sources to refresh through the gateway cluster, it became optional to add gateway for the dataset B.
At least this allowed me to apply the settings. However, when I wanted to refresh dataset A it led to another problem.
I am investigating the issue but if you have a solution, it would me much appreciated
Hi. I'm glad it worked. The new error specifies the issues very clear. "Refresh is not supported for datasets witha calculated table or calculated column that depends on a table which references Analysis Services using Direct Query".
You might have a column that is not allowed using direct query on the tabular model. Please check the model and remove the calculated column (dax). You might be able to try a Measure if it's reaaaaaally necessary.
I hope that helps,
Hi!
Thank you for your responses and time! I appreciate the way you structurely and patiently helped me!
The problem has been solved after I removed calculated columns but I really needed them (however, it's whole another story)