Select all Tables in Azure Blob Storage Parquet Transform Data

[Anonymous]

Hi all!

I am new with Power BI and have trouble understanding how to select all tables when transforming data with an Azure Blob Storage Import. When selecting a Binary file the table shows up and I can use that data for visualization after applying the data transformation.

I would however like to select all tables to visualize data from all 5 tables and transform them all seperately.

The final goal is to load all tables from the Azure Blob Storage and visualize data from all 5 tables.

UPDATA: I currently have a workaround where I create a seperate import for each table. This works fine, but feels cumbersome.

[Anonymous]

Thanks for your quick reply @selimovd!

Your solutions creates converts the parquet files to Tables. This does however not allow me to use and transform the tables seperately. The tables do not have the same structure, but have relations.

The goal is to import the tables as seperate tables, transform them seperately and define relations between them, as shown below. With the workaround of creating 5 seperate imports and selecting a single table in each import the tables show up seperately and I am able to define the relations and transform them seperately.

Kind regards,

Mark

[selimovd]

Hey @Anonymous ,

if they have separate structure, then you have to import each file individually. You can copy the basic query mulitple times, then filter for the file you want to load and only load that file with the "Load Content" button.

Afterwards you can do the transformation you want to do.

Let me know if that works for you.

Best regards

Denis

[Anonymous]

Hey @selimovd ,

The tables have seperate structures. Importing them each individually does work, but I hope in the future there will be functionality added to import them all at once. Creating individual imports for each file in the Azure Blob Storage is not the most elegant solution.

Thanks for your extensive help!

Kind regards,

Mark

[selimovd · Accepted solution]

Hey @Anonymous ,

sure, you have to click on the button in the Content column:

Afterwards, the files should be loaded and combined in one table. You have to make sure that all the files have the same structure.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic