Unable to Import Data From Source From Azure DataLake with Power BI : Error Message 'Failed to save...
I'm using the guide shown here to to Get Data from Azure Data Lake.
https://docs.microsoft.com/en-us/azure/analysis-services/tutorials/aas-lesson-2-get-data
Everything appears to be working fine. However, when I 'Import' from Power BI's Power Query Editor I get the message error message 'Failed to save modifications to the server'. I believe the underlying problem is the column 'Date Created' is Null, but I can't seem to delete the column.
I think the issue has something to do with Permissions, however I am the owner. I have include a few images to illustrate the problem.
azure powerbi azure-data-lake asked Nov 25 '18 at 13:46
peterpeter
185
add a comment |
I'm using the guide shown here to to Get Data from Azure Data Lake.
https://docs.microsoft.com/en-us/azure/analysis-services/tutorials/aas-lesson-2-get-data
Everything appears to be working fine. However, when I 'Import' from Power BI's Power Query Editor I get the message error message 'Failed to save modifications to the server'. I believe the underlying problem is the column 'Date Created' is Null, but I can't seem to delete the column.
I think the issue has something to do with Permissions, however I am the owner. I have include a few images to illustrate the problem.
azure powerbi azure-data-lake asked Nov 25 '18 at 13:46
peterpeter
185
Have you tried to change data types of the columns?
– ygaft
Nov 25 '18 at 21:17
add a comment |
I'm using the guide shown here to to Get Data from Azure Data Lake.
https://docs.microsoft.com/en-us/azure/analysis-services/tutorials/aas-lesson-2-get-data
Everything appears to be working fine. However, when I 'Import' from Power BI's Power Query Editor I get the message error message 'Failed to save modifications to the server'. I believe the underlying problem is the column 'Date Created' is Null, but I can't seem to delete the column.
I think the issue has something to do with Permissions, however I am the owner. I have include a few images to illustrate the problem.
azure powerbi azure-data-lake asked Nov 25 '18 at 13:46
peterpeter
185
I'm using the guide shown here to to Get Data from Azure Data Lake.
https://docs.microsoft.com/en-us/azure/analysis-services/tutorials/aas-lesson-2-get-data
Everything appears to be working fine. However, when I 'Import' from Power BI's Power Query Editor I get the message error message 'Failed to save modifications to the server'. I believe the underlying problem is the column 'Date Created' is Null, but I can't seem to delete the column.
I think the issue has something to do with Permissions, however I am the owner. I have include a few images to illustrate the problem.
azure powerbi azure-data-lake azure powerbi azure-data-lake asked Nov 25 '18 at 13:46
peterpeter
185
asked Nov 25 '18 at 13:46
peterpeter
185
asked Nov 25 '18 at 13:46
peterpeter
185
asked Nov 25 '18 at 13:46
peterpeter
185
asked Nov 25 '18 at 13:46
peterpeter
185
185
Have you tried to change data types of the columns?
– ygaft
Nov 25 '18 at 21:17
add a comment |
Have you tried to change data types of the columns?
– ygaft
Nov 25 '18 at 21:17
Have you tried to change data types of the columns?
– ygaft
Nov 25 '18 at 21:17
Have you tried to change data types of the columns?
– ygaft
Nov 25 '18 at 21:17
add a comment |
1 Answer
1
active
oldest
votes
Cold and hard truth: the issue you are encountering is not because of the date column you are highlighting. Its actually because of the data lake data source.
Solution: unfortunately once you have already created the data source, you cannot go back and change these settings, therefore you HAVE to delete the data source (and all of the tables that you have already created) and recreate it. When you get to the data lake url, put in a value for the "optional" field (I used 100000). And your issue should be resolved!
highlighted is the optional (not really optional field)
answered Jan 22 at 20:48
muffBRmuffBR
1
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%2f53468102%2funable-to-import-data-from-source-from-azure-datalake-with-power-bi-error-mess%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
Cold and hard truth: the issue you are encountering is not because of the date column you are highlighting. Its actually because of the data lake data source.
Solution: unfortunately once you have already created the data source, you cannot go back and change these settings, therefore you HAVE to delete the data source (and all of the tables that you have already created) and recreate it. When you get to the data lake url, put in a value for the "optional" field (I used 100000). And your issue should be resolved!
highlighted is the optional (not really optional field)
answered Jan 22 at 20:48
muffBRmuffBR
1
add a comment |
Cold and hard truth: the issue you are encountering is not because of the date column you are highlighting. Its actually because of the data lake data source.
Solution: unfortunately once you have already created the data source, you cannot go back and change these settings, therefore you HAVE to delete the data source (and all of the tables that you have already created) and recreate it. When you get to the data lake url, put in a value for the "optional" field (I used 100000). And your issue should be resolved!
highlighted is the optional (not really optional field)
answered Jan 22 at 20:48
muffBRmuffBR
1
add a comment |
Cold and hard truth: the issue you are encountering is not because of the date column you are highlighting. Its actually because of the data lake data source.
Solution: unfortunately once you have already created the data source, you cannot go back and change these settings, therefore you HAVE to delete the data source (and all of the tables that you have already created) and recreate it. When you get to the data lake url, put in a value for the "optional" field (I used 100000). And your issue should be resolved!
highlighted is the optional (not really optional field)
answered Jan 22 at 20:48
muffBRmuffBR
1
Cold and hard truth: the issue you are encountering is not because of the date column you are highlighting. Its actually because of the data lake data source.
Solution: unfortunately once you have already created the data source, you cannot go back and change these settings, therefore you HAVE to delete the data source (and all of the tables that you have already created) and recreate it. When you get to the data lake url, put in a value for the "optional" field (I used 100000). And your issue should be resolved!
highlighted is the optional (not really optional field)
answered Jan 22 at 20:48
muffBRmuffBR
1
answered Jan 22 at 20:48
muffBRmuffBR
1
answered Jan 22 at 20:48
muffBRmuffBR
1
answered Jan 22 at 20:48
muffBRmuffBR
1
1
add a comment |
add a comment |
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%2f53468102%2funable-to-import-data-from-source-from-azure-datalake-with-power-bi-error-mess%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
Have you tried to change data types of the columns?
– ygaft
Nov 25 '18 at 21:17