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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
impresent
Frequent Visitor

Get data from existing on-premies SQL dataset to JSON

Hi,

I have a dataset where i imported the data from On-premise SQL database. My requirement is to fetch this dataset data in to a Json file. i have seen some articals on MSDN to get teh dataset / table list.

 

https://msdn.microsoft.com/en-us/library/mt203567.aspx

https://msdn.microsoft.com/en-us/library/mt203556.aspx

 

I am able to get the dataset details but not able to fetch the table details in that dataset. I took two tables from SQL server in the data set. when i use the string 

 

https://api.powerbi.com/v1.0/myorg/groups/{group_id}/datasets/{dataset_id}/tables  

it is giving from 404 error and unable to fetch the details. I am replacing the actual groupid and dataset id in this string. Also i am the owner of that dataset as well.

 

Could you please help me in this scenario ?

 

TIA

Rahul 

 

1 ACCEPTED SOLUTION
Eric_Zhang
Employee
Employee

@impresent

The REST API Get Tables only supports  push datasets and hybrid datasets(streaming dataset with historic data analysis enabled). Since in your case, the dataset is a on-premise SQL Server, the API doesn't work.

Capture.PNG

View solution in original post

1 REPLY 1
Eric_Zhang
Employee
Employee

@impresent

The REST API Get Tables only supports  push datasets and hybrid datasets(streaming dataset with historic data analysis enabled). Since in your case, the dataset is a on-premise SQL Server, the API doesn't work.

Capture.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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