How to get data from Variables type

It is impossible to export directly Variables data, as because it is complex data. In order to get variables for the item, a few tables should be exported and merged using instruments of Power BI Desktop

As an example, variables for Catalog Tasks will be extracted below.

Variables are not directly connected to the tasks. They are connected through the requested_item field from the Options table. Use Power BI Connector to export data from the tables:

Open

And then, use Power BI merged table operation to join table fields and get the results:

Open

NOTE: Take a look at the visible explanation of how Variables connected to data through the tables

Open