With Power BI it's enough to enter OINO.cloud url in the Get Data > From web and add
oinoresponsetype=text/csv-parameter. Power BI will correctly identify data format and create a Power Query table that you can refresh and transform as needed.
You can also use the SQL Parameters to fine tune your data
by filtering and aggregation.
Power BI also correctly identifies the foreign key references in your data and creates the necessary relationships in the Power Query model.
