How secure is Google Sheets - Publish to web, when using for Power Bi report?
I am currently working on a Power BI report, which uses Google Sheets as the data source. As there are no official connectors available, there are two ways to fetch data from sheets to Power BI:
1. Publish to web
2. Link sharing
In both methods, we need to provide a link to Power BI which consists of the ID of the particular spreadsheet. In 'publish to web', any individual with the link can view my data.
So my main concern is, how secure the link sits in power BI? Are there any chances of breach?
google-sheets powerbi powerbi-desktop
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
add a comment |
I am currently working on a Power BI report, which uses Google Sheets as the data source. As there are no official connectors available, there are two ways to fetch data from sheets to Power BI:
1. Publish to web
2. Link sharing
In both methods, we need to provide a link to Power BI which consists of the ID of the particular spreadsheet. In 'publish to web', any individual with the link can view my data.
So my main concern is, how secure the link sits in power BI? Are there any chances of breach?
google-sheets powerbi powerbi-desktop
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
add a comment |
I am currently working on a Power BI report, which uses Google Sheets as the data source. As there are no official connectors available, there are two ways to fetch data from sheets to Power BI:
1. Publish to web
2. Link sharing
In both methods, we need to provide a link to Power BI which consists of the ID of the particular spreadsheet. In 'publish to web', any individual with the link can view my data.
So my main concern is, how secure the link sits in power BI? Are there any chances of breach?
google-sheets powerbi powerbi-desktop
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
I am currently working on a Power BI report, which uses Google Sheets as the data source. As there are no official connectors available, there are two ways to fetch data from sheets to Power BI:
1. Publish to web
2. Link sharing
In both methods, we need to provide a link to Power BI which consists of the ID of the particular spreadsheet. In 'publish to web', any individual with the link can view my data.
So my main concern is, how secure the link sits in power BI? Are there any chances of breach?
google-sheets powerbi powerbi-desktop
google-sheets powerbi powerbi-desktop
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
asked Nov 26 '18 at 7:24
Pratik BhavsarPratik Bhavsar
155
155
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Your concern should not be how the link is secured in Power BI Service, but the existence of this link itself. Lets say the probability of leaking it from your IM/e-mail/correspondence is much higher than leaking from Power BI. You are sharing sensitive data for anonymous access. Don't do that! Find another way for reporting. Either use charting, etc. from Google Sheets, or if you need/must use Power BI, store the data in more convenient place. For example a database in the cloud (Azure SQL Database is a good one). Then build an ETL process to read your data from Google Sheets and push it to the database. This process will be fully authenticated and you will not expose your data.
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
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%2f53476399%2fhow-secure-is-google-sheets-publish-to-web-when-using-for-power-bi-report%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
Your concern should not be how the link is secured in Power BI Service, but the existence of this link itself. Lets say the probability of leaking it from your IM/e-mail/correspondence is much higher than leaking from Power BI. You are sharing sensitive data for anonymous access. Don't do that! Find another way for reporting. Either use charting, etc. from Google Sheets, or if you need/must use Power BI, store the data in more convenient place. For example a database in the cloud (Azure SQL Database is a good one). Then build an ETL process to read your data from Google Sheets and push it to the database. This process will be fully authenticated and you will not expose your data.
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
add a comment |
Your concern should not be how the link is secured in Power BI Service, but the existence of this link itself. Lets say the probability of leaking it from your IM/e-mail/correspondence is much higher than leaking from Power BI. You are sharing sensitive data for anonymous access. Don't do that! Find another way for reporting. Either use charting, etc. from Google Sheets, or if you need/must use Power BI, store the data in more convenient place. For example a database in the cloud (Azure SQL Database is a good one). Then build an ETL process to read your data from Google Sheets and push it to the database. This process will be fully authenticated and you will not expose your data.
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
add a comment |
Your concern should not be how the link is secured in Power BI Service, but the existence of this link itself. Lets say the probability of leaking it from your IM/e-mail/correspondence is much higher than leaking from Power BI. You are sharing sensitive data for anonymous access. Don't do that! Find another way for reporting. Either use charting, etc. from Google Sheets, or if you need/must use Power BI, store the data in more convenient place. For example a database in the cloud (Azure SQL Database is a good one). Then build an ETL process to read your data from Google Sheets and push it to the database. This process will be fully authenticated and you will not expose your data.
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
Your concern should not be how the link is secured in Power BI Service, but the existence of this link itself. Lets say the probability of leaking it from your IM/e-mail/correspondence is much higher than leaking from Power BI. You are sharing sensitive data for anonymous access. Don't do that! Find another way for reporting. Either use charting, etc. from Google Sheets, or if you need/must use Power BI, store the data in more convenient place. For example a database in the cloud (Azure SQL Database is a good one). Then build an ETL process to read your data from Google Sheets and push it to the database. This process will be fully authenticated and you will not expose your data.
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
answered Nov 26 '18 at 8:21
Andrey NikolovAndrey Nikolov
4,3333922
4,3333922
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
add a comment |
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Thanks a lot for sharing your views on this. In fact, I myself was thinking on the same lines. Can you please suggest the best ETL tool to get this done? I was thinking of Microsoft Flow to pull data from Google Sheets & then push in Azure SQL. Please guide further.
– Pratik Bhavsar
Nov 26 '18 at 8:59
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
Unfortunately, I can't advise you which tool is "the best". This is quite subjective. I feel comfortable writing my own ETL for this, while others will prefer pre-made solution. Just use that one, which you feel comfortable with and you know best. If it works for you, it may be "the best" for you too :)
– Andrey Nikolov
Nov 26 '18 at 9:16
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%2f53476399%2fhow-secure-is-google-sheets-publish-to-web-when-using-for-power-bi-report%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
