Import data from azure table storage but don't contain any columns after expanding

[VanceTsai]

Hi guys! This situation make me very confused and don't have any clue to fix it.

In my case, I connect to Azure table storage to get data and there're some columns been folded, 

so I click transform data into Power Query Editor to expand the folded columns.

However, this (see data_1 below) happened and only happaned in specific one data (called data_1)

but when I choose data_2 , I can see the folded columns and expand normally. 

I use exactly the same way and same data source to get the data_1 and data_2.

data_1 (I covered the RowKey)

data_2

Been struggling for couple weeks, please help.

Thanks!

[sally132435]

Hi Vance,

I have encounter similar issue at work before. Me and my team are using Power Bi to connect to Azure datalake table and I am the only one who can't expand a particular table but all my other coworker can. Here is how we find the bugs that Microsoft need to work on.

1.Connect to the data source in power bi

2.Click the table and click "Transform Data" 

3.Right click the table at which you want to expand from table section at right then click "Advance Editor"

4.COPY the full query from other user who already successfully expand the table and REPLACE all the query you have.

5. Viola! you will have the table expanded.

Hope this method helps!

[VanceTsai]

Hi @sally132435 

I try your solution and it worked, thanks.

But there're some weird situation here, it might be a bug?

1. Connect to azure storage table, get the data_1 and try to transform data to expand it

and you can see the content (folded columns) show "No columns were found."

2. Then I try your way, use Advanced Editor to write the Query

Query : 

I can expand the columns successfully.

3. I go back to check the If the content is been expand or not.

You can see the content (folded columns) still show "No columns were found." 

This situation is really weird.

[v-diye-msft · Accepted solution]

Hi @VanceTsai 

Current power bi not support to expand records type, you need to manly do it though record function.(e.g. add custom column with record functions to extract specific fields values from record type column)

BTW, you can also take a look at following links:

Guy in a Cube - How to expand a list of records in a query

Record functions

Reference links:

Record.ReorderFields	Returns a new record that reorders fields relative to each other. Any fields not specified remain in their original locations. Requires two or more fields.
Record.SelectFields	Returns a new record that contains the fields selected from the input record. The original order of the fields is maintained.
Record.ToTable	Returns a table of records containing field names and values from an input record.

[Greg_Deckler]

@VanceTsai - Not sure if I am following - You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[amitchandak]

@VanceTsai , open a few rows of data in a text file and check if there is some issues or not.

Can you share sample data?

Also, check if it showing error somewhere in that column.

refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s

[VanceTsai]

Hi @amitchandak 

data_1 in azure table (I covered the RowKey and Account_id) : 

you can tell the original data in Azure tables storage is fine.