Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm with Premium per User License.
I want to use Power BI Dataset especially Measures in my Sharepoint site using XMLA Endpoint.
For Example:
I have created a measure in Power BI
XYZ=SUM(Table[ColumnName])
I want to use/show this measure results on SharePoint using the XMLA endpoint.
Let me know is it possible?
How can I get XMLA endpoint measures in SharePoint?
How can I do so?
Solved! Go to Solution.
I got step by step guide on how to use XMLA endpoints using rest API. Using HTTP in SharePoint I can access my DAX measures directly in my SharePoint site from Power BI.
This is what I was looking for
I got step by step guide on how to use XMLA endpoints using rest API. Using HTTP in SharePoint I can access my DAX measures directly in my SharePoint site from Power BI.
This is what I was looking for
Hey @adeelnazir ,
I have to admit that I have no idea what you want to achieve, please explain your requirement in more detail.
In regards to the XMLA feature, this feature provides an endpoint that can be used by all appllications that are able to connect to an XMLA endpoint like SQL Server Management Studio, DAX Studio, Tabular Editor, and of course 3rd party BI tools like Tableau.
You can also using the XMLA endpoint by creating your own application by leveraging functionality of Power BI REST API or .net core libraries.
If you "just" want to embed a Power BI report into a SharePoint online site you can use this feature: https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-report-spo
Regards,
Tom
For Example:
I have created a DAX measure in Power BI
XYZ := SUM(Table[ColumnName])
I want to use/show this measure results on SharePoint using the XMLA endpoint.
Let me know is it possible?
How can I get XMLA endpoint measures in SharePoint?
Based on your response I feel Power BI REST API can help get dataset's measure results?
Let me know the API steps that I need to use, in order to achieve my goal.
Hey @adeelnazir ,
I consider it not possible to connect from SharePoint to a Power BI dataset using the XMLA endpoint. This is because SharePoint does not natively connects to data sources using the XMLA endpoint connection type.
For this reason, I recommend I recommend creating a report in Power BI end then embedding this report into a Share Point site: Embed a report web part in SharePoint Online - Power BI | Microsoft Docs
Hopefully, this provides a new idea on how to tackle your challenge.
Regards,
Tom
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.