Pre-filtering/selecting data before Importing to Power BI from Azure Table Storage data source

Hi KetD 

You could use Excel to load the data from Azure Table Storage, do your transformations in PQ and then output the data into a table on a worksheet.

You can then load the table from the Excel file into PBI.

Regards

Phil

Hi, KetD 

Before we import the data to Power BI from a data source, we usually use Power query editor to filter the useless data to enable them from loading into the Power BI, you can check these two documents:

https://yodalearning.com/tutorials/learn-how-filter-records-using-power-query/

https://support.microsoft.com/en-us/office/filter-a-table-power-query-b5610630-f5bf-4ba4-9217-a628f9b89353

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your inputs.

I am more looking into something like oData queries Or Table Storage REST APIs(I am not sure APIs is right approach or not) where we can eliminate columns by putting filter/select.

Something like this - 

https://myaccount.table.core.windows.net/Customers(PartitionKey='MyPartition',RowKey='MyRowKey1')

I am new to Power BI and can't find any documentation on how to use oData queries with Azure Table Storage.

Any inputs will be helpful.

Thank you!