Forum Discussion
How to programmatically generate "Script Database as" output for power bi models
Can I use "mssql-scripter' to connect to power bi to programmatically generate "Script Database as" output for power bi models. if "mssql-scripter' won't work with analysis services database, the...
Hi SriThiru
You can connect to an XMLA endpoint for a Dataset, if that Dataset is stored on a "Premium Capacity" or "Premium Per User" workspace. In this case it's possible that the workspace with the Dataset you're trying to connect to is not one of those.
See : Dataset connectivity and management with the XMLA endpoint in Power BI - Power BI | Microsoft Docs
Hope this helps
Stuart