Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Select all Tables in Azure Blob Storage Parquet Transform Data

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.

 

power_bi_select_all_tables.png

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

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @Anonymous ,

 

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

selimovd_0-1637070246034.png

 

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
 

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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.

 

power_bi_combine_files.png

 

 

 

 

 

 

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.

 

power_bi_goal.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Kind regards,

 

Mark

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
Not applicable

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
Super User
Super User

Hey @Anonymous ,

 

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

selimovd_0-1637070246034.png

 

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
 

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors