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

[KetD]

Hello,

I want to use Azure Table Storage datasource to load the data in PowerBI. The amount of data is very large that will hit performance issues eventually. Is there any way I can select/filter the data before importing to PowerBI?

I read here in one post that we can use oData. Any inputs on how to use oData queries for table storage?

Thank you!

[KetD]

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!

[v-robertq-msft]

Hi, @KetD 

According to your description, you want to do some oData queries Or Table Storage REST APIs with Azure Table Storage, you can check these documents to find if they can help you:

https://docs.microsoft.com/en-us/rest/api/storageservices/querying-tables-and-entities

https://docs.microsoft.com/en-us/rest/api/storageservices/query-tables

https://docs.microsoft.com/en-us/rest/api/storageservices/query-entities

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.

[v-robertq-msft]

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-a628f9...

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.

[PhilipTreacy]

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