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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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