Forum Discussion
Excel Not Refreshing Data from Power BI Semantic Model (Live Connection via XLMA)
Hi everyone, I'm trying to create a fully automated reporting process by connecting an Excel workbook directly to a Power BI semantic model using the XLMA endpoint (live connection). The goal is t...
IMHO, XMLA endpoint works with Premium capacity. Plus there are some limitations on semantic model. With Pro license works connection established as Data-> Get Data-> From Fabric & Power Platform -> From Power BI -> select semantic model -> Insert PivotTable (or Table).