It is possible to convert dataset (pbix) File to JSON File Format

[chundrub]

Hi team,

In our present work scenrio we would like to get the data from an Power BI dataset .Our plan is to download the PBIX dataset file in JSON format and load the data into SQL DB(Required) using ADF Pipeline .Any suggestion on the below query could help us 

Thanks in Advance

[v-yiruan-msft]

Hi @chundrub ,

It seems that you want to export Power BI Data into SQL Server finally, please check if the methods in the following links can be used as alternatives...

1. With R or using SSIS

Exporting Power BI Data to SQL Server

2. Powershell

Export Power BI Desktop data to SQL Server

3. Using API

Export Filtered Dataset from Power BI to SQL Server Programmatically using API and Power BI Embedded

Best Regards

[amitchandak]

@chundrub , You can check the option available in the Tabular editor. It can save model in a text format 

https://www.sqlbi.com/tools/tabular-editor/