How to query values only from Azure Blob Storage with Excel Power Query?Stop Excel from automatically converting certain text values to datesChecking if a blob exists in Azure StorageExcel Power Query — Select value in column specified in related table — INDEX+MATCH alternativeHow to Power Query Windows folder-share security/access permissions?Format Rows and Columns in Excel Power Query Based on Source Tableexisting excel formulas into power queryUsing power query on excel workbooks with autofilter pulls data from the wrong columnsFeed cell value into excel query web browser URLParameter whole range or table in Excel Power QueryExcel power query different size web tables
Fast method to cut/shred glue stick into small pieces
Perform mirror symmetry transformation of 3D model (in OBJ)
Where to connect the fuse and why?
How to track mail undetectably?
Why was Pan Am Flight 103 flying over Lockerbie?
Why didn't Caesar move against Sextus Pompey immediately after Munda?
I just started; should I accept a farewell lunch for a coworker I don't know?
What overwrites /etc/resolv.conf roughly every hour?
Why do some PCBs have exposed plated perimeters?
What are the children of two Muggle-borns called?
Installed software from source, how to say yum not to install it from package?
Do electrons really perform instantaneous quantum leaps?
What are the advantages and disadvantages of Manhattan-Style routing?
Is it OK to throw pebbles and stones in streams, waterfalls, ponds, etc.?
Automorphisms and epimorphisms of finite groups
The alcoholic village festival
Avoiding repetition when using the "snprintf idiom" to write text
What was the first science fiction or fantasy multiple choice book?
What does 5d4 x 10 gp mean?
Having to constantly redo everything because I don't know how to do it
Could you fall off a planet if it was being accelerated by engines?
Tricolour nonogram
How far can gerrymandering go?
Is it possible to alias a column based on the result of a select+where?
How to query values only from Azure Blob Storage with Excel Power Query?
Stop Excel from automatically converting certain text values to datesChecking if a blob exists in Azure StorageExcel Power Query — Select value in column specified in related table — INDEX+MATCH alternativeHow to Power Query Windows folder-share security/access permissions?Format Rows and Columns in Excel Power Query Based on Source Tableexisting excel formulas into power queryUsing power query on excel workbooks with autofilter pulls data from the wrong columnsFeed cell value into excel query web browser URLParameter whole range or table in Excel Power QueryExcel power query different size web tables
I am trying to query some chatbot data from Azure Blob Storage with Excel Power Query. Unfortunately, Excel cells not only contain the value but also the key in each cell.
This is some sample content of a blob in my blobstorage. The data always has the same structure.
"id":"3398","realId":"3398","document":"userID":"3398","name":"Testdurchgang","age":18,"gender":"männlich","education":"Diplom","complete":true,"advisoryConversationId":"6EFa4fsLaJhB4U1LlwNksU-f","roundCounter":5,"riskchoices":["A","A","A","A","B","B","B","B","B","B"],"riskAssessmentComplete":true,"riskDescription":"risikoneutral","order":["2","1","0"],"botRecommendation":"Breen GmbH","choice":"ACG GmbH","follow":false,"eTag":"*","resultConversationId":"Kxw9FZ2KwdWKqElSQQ0nG2-f","win1":"none","win2":"ACG GmbH","loss1":"Breen GmbH","loss2":"Plus GmbH","payout":"Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.","payoutNumber":"6,5"
This is how the data looks like in the Power Query tool:
As you can see, the first column even contains the bracket from the JSON and column 3 contains the "content" tag. In the best case, I want only the value in each cell. I can set the column description manually if necessary.
Is there a way to achieve this?
I know I could do it with Excel functions but this would not be a really nice solution.
Thank you in advance.
json excel
azure powerquery azure-blob-storage asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
add a comment |
I am trying to query some chatbot data from Azure Blob Storage with Excel Power Query. Unfortunately, Excel cells not only contain the value but also the key in each cell.
This is some sample content of a blob in my blobstorage. The data always has the same structure.
"id":"3398","realId":"3398","document":"userID":"3398","name":"Testdurchgang","age":18,"gender":"männlich","education":"Diplom","complete":true,"advisoryConversationId":"6EFa4fsLaJhB4U1LlwNksU-f","roundCounter":5,"riskchoices":["A","A","A","A","B","B","B","B","B","B"],"riskAssessmentComplete":true,"riskDescription":"risikoneutral","order":["2","1","0"],"botRecommendation":"Breen GmbH","choice":"ACG GmbH","follow":false,"eTag":"*","resultConversationId":"Kxw9FZ2KwdWKqElSQQ0nG2-f","win1":"none","win2":"ACG GmbH","loss1":"Breen GmbH","loss2":"Plus GmbH","payout":"Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.","payoutNumber":"6,5"
This is how the data looks like in the Power Query tool:
As you can see, the first column even contains the bracket from the JSON and column 3 contains the "content" tag. In the best case, I want only the value in each cell. I can set the column description manually if necessary.
Is there a way to achieve this?
I know I could do it with Excel functions but this would not be a really nice solution.
Thank you in advance.
json excel
azure powerquery azure-blob-storage asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
add a comment |
I am trying to query some chatbot data from Azure Blob Storage with Excel Power Query. Unfortunately, Excel cells not only contain the value but also the key in each cell.
This is some sample content of a blob in my blobstorage. The data always has the same structure.
"id":"3398","realId":"3398","document":"userID":"3398","name":"Testdurchgang","age":18,"gender":"männlich","education":"Diplom","complete":true,"advisoryConversationId":"6EFa4fsLaJhB4U1LlwNksU-f","roundCounter":5,"riskchoices":["A","A","A","A","B","B","B","B","B","B"],"riskAssessmentComplete":true,"riskDescription":"risikoneutral","order":["2","1","0"],"botRecommendation":"Breen GmbH","choice":"ACG GmbH","follow":false,"eTag":"*","resultConversationId":"Kxw9FZ2KwdWKqElSQQ0nG2-f","win1":"none","win2":"ACG GmbH","loss1":"Breen GmbH","loss2":"Plus GmbH","payout":"Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.","payoutNumber":"6,5"
This is how the data looks like in the Power Query tool:
As you can see, the first column even contains the bracket from the JSON and column 3 contains the "content" tag. In the best case, I want only the value in each cell. I can set the column description manually if necessary.
Is there a way to achieve this?
I know I could do it with Excel functions but this would not be a really nice solution.
Thank you in advance.
json excel
azure powerquery azure-blob-storage asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
I am trying to query some chatbot data from Azure Blob Storage with Excel Power Query. Unfortunately, Excel cells not only contain the value but also the key in each cell.
This is some sample content of a blob in my blobstorage. The data always has the same structure.
"id":"3398","realId":"3398","document":"userID":"3398","name":"Testdurchgang","age":18,"gender":"männlich","education":"Diplom","complete":true,"advisoryConversationId":"6EFa4fsLaJhB4U1LlwNksU-f","roundCounter":5,"riskchoices":["A","A","A","A","B","B","B","B","B","B"],"riskAssessmentComplete":true,"riskDescription":"risikoneutral","order":["2","1","0"],"botRecommendation":"Breen GmbH","choice":"ACG GmbH","follow":false,"eTag":"*","resultConversationId":"Kxw9FZ2KwdWKqElSQQ0nG2-f","win1":"none","win2":"ACG GmbH","loss1":"Breen GmbH","loss2":"Plus GmbH","payout":"Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.","payoutNumber":"6,5"
This is how the data looks like in the Power Query tool:
As you can see, the first column even contains the bracket from the JSON and column 3 contains the "content" tag. In the best case, I want only the value in each cell. I can set the column description manually if necessary.
Is there a way to achieve this?
I know I could do it with Excel functions but this would not be a really nice solution.
Thank you in advance.
json excel
azure powerquery azure-blob-storage json excel
azure powerquery azure-blob-storage asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
edited Mar 25 at 17:35
FRANZKAFKA
asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
asked Mar 25 at 15:38
FRANZKAFKAFRANZKAFKA
3310 bronze badges
3310 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Make sure the file you have stored in Storage blob container is of .json format.
Was able to upload your sample content into blob as below
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
In excel was able to import
Click on Binary and should see below
Click on Record and should see the below
Insert into the table should show something as below
Hope the above steps help !
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55341427%2fhow-to-query-values-only-from-azure-blob-storage-with-excel-power-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Make sure the file you have stored in Storage blob container is of .json format.
Was able to upload your sample content into blob as below
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
In excel was able to import
Click on Binary and should see below
Click on Record and should see the below
Insert into the table should show something as below
Hope the above steps help !
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
add a comment |
Make sure the file you have stored in Storage blob container is of .json format.
Was able to upload your sample content into blob as below
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
In excel was able to import
Click on Binary and should see below
Click on Record and should see the below
Insert into the table should show something as below
Hope the above steps help !
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
add a comment |
Make sure the file you have stored in Storage blob container is of .json format.
Was able to upload your sample content into blob as below
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
In excel was able to import
Click on Binary and should see below
Click on Record and should see the below
Insert into the table should show something as below
Hope the above steps help !
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
Make sure the file you have stored in Storage blob container is of .json format.
Was able to upload your sample content into blob as below
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
In excel was able to import
Click on Binary and should see below
Click on Record and should see the below
Insert into the table should show something as below
Hope the above steps help !
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
"id": "3398",
"realId": "3398",
"document":
"userID": "3398",
"name": "Testdurchgang",
"age": 18,
"gender": "männlich",
"education": "Diplom",
"complete": true,
"advisoryConversationId": "6EFa4fsLaJhB4U1LlwNksU-f",
"roundCounter": 5,
"riskchoices": [
"A",
"A",
"A",
"A",
"B",
"B",
"B",
"B",
"B",
"B"
],
"riskAssessmentComplete": true,
"riskDescription": "risikoneutral",
"order": [
"2",
"1",
"0"
],
"botRecommendation": "Breen GmbH",
"choice": "ACG GmbH",
"follow": false,
"eTag": "*",
"resultConversationId": "Kxw9FZ2KwdWKqElSQQ0nG2-f",
"win1": "none",
"win2": "ACG GmbH",
"loss1": "Breen GmbH",
"loss2": "Plus GmbH",
"payout": "Du bekommst 6500 Geldeinheiten = 6,50€ ausgezahlt.",
"payoutNumber": "6,5"
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
answered Mar 25 at 23:04
bharathn-msftbharathn-msft
3405 bronze badges
3405 bronze badges
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
add a comment |
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
Your very first sentence was my problem: The data was in json format but the blobs were not specified as .json. By manually uploading a .json file from my harddrive I could replicate the behavior. Unfortunately, this way I can only load the content of a single file into the spreadsheet. By not specifying the extension, I was able to get a table in excel in which each column represents a key and the different values (about 200 per key) are represented below, which is necessary for analyzing the data (e.g. frequency distribution).
– FRANZKAFKA
Mar 26 at 10:46
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
I understand that this way you can only load the content of a single file. However please check if you can reformat your json files to just have the document section, that might help you load all the files at once.
– bharathn-msft
Mar 26 at 14:00
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55341427%2fhow-to-query-values-only-from-azure-blob-storage-with-excel-power-query%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
