How to make Power BI recognize dynamic columns in Azure Table Storage

[Leonzzheng]

I recently added some dynamic columns for data storing in Azure Table Storage. For example, the most of rows in this table will have 6 columns, but some new rows will have 6, 7, 8, or even more columns. All these columns are shown in Microsoft Azure Storage Explorer without any problem.

However, when I tried to use Power BI to create report, it will not show the extra columns, all data will only have 6 columns. Even when I add filter to query the new rows which should have more than 6 columns, it still show just 6 columns. I learnt that Power BI will only show columns as the top certain amount rows' columns, is there anyway I can predefine the extra columns and let Power BI recognize them so that I can add filters?

Thanks!

[lbendlin]

Which connector are you using?  For example in the CSV connector on the initial load the number of columns is added to the source definition but you can remove that again in case your CSV file has dynamic columns.

[Leonzzheng]

I connect to database by link and key