![]() ![]() For a deeper dive into these features and more, continue reading below. This release includes several new features, and some less visible but still notable improvements. Welcome to Storage Explorer version 1.22.0. I’ll write blog posts about both of them.December 2021 (Version 1.22.0, build 20211211.10) There are multiple ways to achieve that – two of them are Azure Functions and Azure WebJobs. So the next step is to run the script automatically so that the Azure Table gets filled periodically. The data is currently added manually each time I execute the script. ![]() So everythings configured, press close & load, modify some columns (format as datetime) and the result is there:įrom now on, everytime I open this Excel, I can easily refresh the data by clicking “Refresh” in the Data Ribbon. Press the small button at the “content” column and ok: Click on “edit” as we also want to show our “custom” (content) columns: You should now be able to select the table and load the data. Next step is to enter the storage account name and the Account Key (one of the Access Keys). Open Excel, navigate to the Data Ribbon and add a new query: Looks good, so let’s continue… Read Azure Table Storage using Excel So let’s check if the data is there, before we connect Excel: ![]() It allows us to browse and modify the stuff in our storage account. There is a really great, useful and free tool available – the storage explorer (Download ). The script executed without an error, but is the data really stored? Read Azure Table Storage using Storage Explorer $rowKey = $entry.'post-id'.InnerText.PadLeft(5, '0') #add 0 at beginning for sortingĪdd-Entity $table "CodeHollow" $rowKey $values The whole script, including the connection and a check if the table already exists: function GetOrCreateTable ($storageContext, $tableName) The commandlet to create a storage table is New-AzureStorageTable. If it isn’t already loaded, execute the following lines: Import-Module AzureRM.Profile These commandlets are part of the Azure.Storage module. There are already some basic commandlets available to create a table in the Azure Storage. But before jumping into the script, we should copy the storage access key which can be found in the Settings – “Access Keys”: I’ll use, as usual, my beloved Powershell. So it seems we have to do it another way. We can see that there is no “create table” button available. The next step is to create a table in the table storage – so let’s check it in the Azure portal: I decided to use the cheapest version (locally-redundant storage) with standard performance and without encryption, because I’ll only use it for small data which I will fill programmatically and show in Excel. The first step is to create a storage account in the Azure Portal. Check if data is there (storage explorer).After that I’ll connect Excel to the table storage. In this blog post, I will create a table storage and put only a few records in it. Troy Hunt used it with 154 million records – and it worked like a charm!. That’s nearly nothing, because it is designed to work with tons of data. It’s easy to programmatically write data to the table storage and with the Excel/PowerBI connection, it’s great to use it for data analysis or for dynamic Excel files.Īdditionally, the Azure table storage is very cheap! 1 GB storage + 100.000 transactions = 0.06€ per month. You can connect to the table storage with Excel, Access and – by sure – with PowerBI. Azure table storage is a NoSql table and it’s great for storing tons of data, but it’s also good for just a few records. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |