Forum Discussion
Get Data through XMLA endpoint
Hi Everyone,
Is it possible to pull only necessary columns from a dataset through XMLA endpoint (SQL Server Analysis Services database connector)?
We've been trying to do this. We're trying to replicate a visual from another Power BI report and we're using the same dataset through the XMLA endpoint. For example, for one KPI card, we only pull the columns used but it gives us a different result.
Tried to dig the internet but can't find any related documentation.
Hoping to get some help with this.
Thank you so much!
3 Replies
- lbendlin
Super User
When you connect to an XMLA endpoint you're live connecting to a data model, and your rendering tool (Excel etc) will run XMLA queries against the source to pull only the data required for rendering. Is that what you are asking?
v-yingjlCommunity Support
Hi Anonymous ,
Sorry for replying late. Currently we can use XMLA endpoint to read/write, refer:
- How to Export Data from Power BI using XMLA Endpoints
- Demystifying the Power BI XMLA Endpoint
- Dataset connectivity with the XMLA endpoint (Preview)
Best Regards,
Yingjie LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- v-yingjl
Hi Anonymous ,
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!
Best Regards,
Yingjie Li
