This week’s Power BIte is the third in a series of videos[1] that present different ways to create new Power BI dataflows, and the results of each approach.
When creating a dataflow by importing a model.json file previously exported from Power BI, the dataflow will have the following characteristics:
Attribute | Value |
---|---|
Data ingress path | Ingress via the mashup engine hosted in the Power BI service. |
Data location | Data stored in the CDM folder defined for the newly created dataflow |
Data refresh | The dataflow is refreshed based on the schedule and policies defined in the workspace. |
Let’s look at the dataflow’s model.json metadata to see some of the details.
At the top of the file we can see the dataflow name on line 2…
…and that’s pretty much all that’s important here. The rest of the model.json file will exactly match what was exported from the Power BI portal, and will look a lot like this or this. Boom.
For a little more detail (and more pictures, in case you don’t want to watch a four minute video) check out this post from last month, when this capability was introduced.
If this information doesn’t make sense yet, please hold on. We still have one more incoming Power BIte in this series, and then we’ll have the big picture view.
I guarantee[3] it will make as much sense as anything on this blog.
[1] New videos every Monday morning![2]
[2] Did you notice that I just copied the previous post and made some small edits to it? That seemed very appropriate given the topic…
[3] Or your money back.
Hi Matthew, i have a “stupid question” for you ! When I export the dataflow JSON file and try and view it in notepad ++ as an example (and turn on JSON language mode) – its just not formatting correctly. Even notepad normally shows JSON in a readable format – but the file produced seems to be just one loooonnngg string. What JSON viewer do you use ?
LikeLike
I use VS code, but Notepad++ should be able to “pretty format” JSON with the right add-in
https://stackoverflow.com/questions/1560464/how-to-reformat-json-in-notepad
LikeLike