Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Lbalubaid94
Frequent Visitor

Can I create Dataset using XMLA Endpoint ?

Dears , 

 

  • I searched in many websites about it but no luck if i can use XMLA endpoint to create a live dataset? if so please can you guide me on a tutorial how to make it?
  • another question , may I connect it to Kafka ? 
  • How I can benefit from XMLA Endpoint?

Thabk you for yout help in advance.

3 REPLIES 3
JirkaZ
Solution Specialist
Solution Specialist

Datasets cannot be created using the API. You have to create them in Power BI Desktop or service (if you are talking about the push or streaming dataset). 

You can then insert rows into the dataset from any system you want (probably using the API - Push Datasets - Datasets PostRows - REST API (Power BI Power BI REST APIs) | Microsoft Docs)

 

 

 

Thank you for replying , so about the other question ? Can I connect it to kafka or use it on kafka ?

 

You can query the dataset using the XMLA endpoint (example here) How to Export Data from Power BI using XMLA Endpoints - sqlitybi

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors