Search code examples
jsonpowerbipowerbi-datasource

Rest URL as data source to Power BI

I am using a Rest URL as data source to Power BI. That URL returns JSON data in the following format.

[
    {
        "Count": 8,
        "Email": "[email protected]",
        "Title": "My Title 1"
    },
    {
        "Count": 10,
        "Email": "[email protected]",
        "Title": "My Title 2"
    }
]

PowerBI is able to pull data from the Rest URL provided. But it is showing data in the following format.

enter image description here

It is not showing data as table. I have searched for the solution but din't find one.

This SO Question describes the same issue but the solution given did not work for me. (There is no small box with two arrows beside each record as explained in the answer)

Solution

  • Just convert list to table and arrows appear

    enter image description here