JSON output of POWER BI Schema

[Anonymous]

Hi Expert,

How to get JSON export file of power bi schema 

Shree

[parry2k]

@Anonymous I don't think it is possible. check Power BI Helper tool, may be it has the ability to export it.

[Anonymous]

Hi Expert,

in this post they did it

https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/

shree

[parry2k]

@Anonymous That is exporting the data not data model.

[Anonymous]

Hi Expert,

yes but initial stages it is passing parameters to get data in the form of json...Please check below steps

1. Transform your error-table into a list of records (as that is the format of a JSON-array that Flow likes):
   • row 3: Table.ToRecords(<YourTableName>)
2. Transform that into a JSON-binary that the Web.Contents-function can digest:
   • row 4: Json.FromValue(<YourListOfRecordsFromAbove>)
3. Make the Web-call to the copied URL (use Anonymus credentials):
   • row 5-7: Web.Contents(<PasteTheURLFromFlowHere>, [Content=<JsonFromAbove>])
4. Parse the result and load this query to the datamodel (this is very important, because otherwise the WebCall wouldn’t be made if the dataset is refreshed!):
   • row 8: Lines.FromBinary(<WebCallFromAbove>)