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. 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)