Connecting Power BI to access database over networkHow to provide user name and password when connecting to a network shareViewing my IIS hosted site on other machines on my networkHow can I connect to Android with ADB over TCP?Connecting to MySQL Database over serverGet local IP addressclarification in the connection string for accessing database over lanprotect network shared access databaseOpen an Access 2007 database in a shared network folder from a button on another databasePower BI can't access Godaddy's DatabaseMultiuser SQL Powered Access Database Over Network
How to have the "Restore Missing Files" function from Nautilus without installing Nautilus?
How to solve this inequality , when there is a irrational power?
German equivalent to "going down the rabbit hole"
Datasets of Large Molecules
Can a human variant take proficiency in initiative?
Turn off Google Chrome's Notification for "Flash Player will no longer be supported after December 2020."
Punishment in pacifist society
meaning of "educating the ice"?
Is the equational theory of groups axiomatized by the associative law?
In Toy Story, are toys the only inanimate objects that become alive? And if so, why?
Displaying Time in HH:MM Format
'spazieren' - walking in a silly and affected manner?
What is causing gaps in logs?
Cheap oscilloscope showing 16 MHz square wave
Are there balance issues when allowing attack of opportunity against any creature?
How can I portray a character with no fear of death, without them sounding utterly bored?
Could a simple hospital oxygen mask protect from aerosol poison?
Does a Rogue's proficiency with a Rapier apply to the Spiral Rapier?
Received email from ISP saying one of my devices has malware
Get rows that exist exactly once per day for a given period
Why do modes sound so different, although they are basically the same as a mode of another scale?
Single vs Multiple Try Catch
What happens if you just start drawing from the Deck of Many Things without declaring any number of cards?
How to run a command 1 out of N times in Bash
Connecting Power BI to access database over network
How to provide user name and password when connecting to a network shareViewing my IIS hosted site on other machines on my networkHow can I connect to Android with ADB over TCP?Connecting to MySQL Database over serverGet local IP addressclarification in the connection string for accessing database over lanprotect network shared access databaseOpen an Access 2007 database in a shared network folder from a button on another databasePower BI can't access Godaddy's DatabaseMultiuser SQL Powered Access Database Over Network
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have a database that is stored on my local machine. I would like users on my network to access that database through power bi. Can someone point me in the right direction?
ms-access networking access-vba powerbi
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
|
show 3 more comments
I have a database that is stored on my local machine. I would like users on my network to access that database through power bi. Can someone point me in the right direction?
ms-access networking access-vba powerbi
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
1
You could use the access options to export to SharePoint or MS SQL Server. There might a little bit of rework on forms or reports, but at that point access is just the front end and you have a backend data source that is more friendly to business intelligence data sharing.
– user9105725
Mar 28 at 0:34
I don’t want to have to export every time I need the data tho.
– ChronoBrother
Mar 28 at 0:40
You don’t need to. It’s a one time deal. Access will connect directly to the external data source.
– user9105725
Mar 28 at 0:41
Might be worthwhile microsoft.com/en-us/download/details.aspx?id=54255
– user9105725
Mar 28 at 0:52
support.office.com/en-us/article/…
– user9105725
Mar 28 at 1:40
|
show 3 more comments
I have a database that is stored on my local machine. I would like users on my network to access that database through power bi. Can someone point me in the right direction?
ms-access networking access-vba powerbi
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
I have a database that is stored on my local machine. I would like users on my network to access that database through power bi. Can someone point me in the right direction?
ms-access networking access-vba powerbi
ms-access networking access-vba powerbi
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
asked Mar 28 at 0:26
ChronoBrotherChronoBrother
65 bronze badges
65 bronze badges
1
You could use the access options to export to SharePoint or MS SQL Server. There might a little bit of rework on forms or reports, but at that point access is just the front end and you have a backend data source that is more friendly to business intelligence data sharing.
– user9105725
Mar 28 at 0:34
I don’t want to have to export every time I need the data tho.
– ChronoBrother
Mar 28 at 0:40
You don’t need to. It’s a one time deal. Access will connect directly to the external data source.
– user9105725
Mar 28 at 0:41
Might be worthwhile microsoft.com/en-us/download/details.aspx?id=54255
– user9105725
Mar 28 at 0:52
support.office.com/en-us/article/…
– user9105725
Mar 28 at 1:40
|
show 3 more comments
1
You could use the access options to export to SharePoint or MS SQL Server. There might a little bit of rework on forms or reports, but at that point access is just the front end and you have a backend data source that is more friendly to business intelligence data sharing.
– user9105725
Mar 28 at 0:34
I don’t want to have to export every time I need the data tho.
– ChronoBrother
Mar 28 at 0:40
You don’t need to. It’s a one time deal. Access will connect directly to the external data source.
– user9105725
Mar 28 at 0:41
Might be worthwhile microsoft.com/en-us/download/details.aspx?id=54255
– user9105725
Mar 28 at 0:52
support.office.com/en-us/article/…
– user9105725
Mar 28 at 1:40
1
1
You could use the access options to export to SharePoint or MS SQL Server. There might a little bit of rework on forms or reports, but at that point access is just the front end and you have a backend data source that is more friendly to business intelligence data sharing.
– user9105725
Mar 28 at 0:34
You could use the access options to export to SharePoint or MS SQL Server. There might a little bit of rework on forms or reports, but at that point access is just the front end and you have a backend data source that is more friendly to business intelligence data sharing.
– user9105725
Mar 28 at 0:34
I don’t want to have to export every time I need the data tho.
– ChronoBrother
Mar 28 at 0:40
I don’t want to have to export every time I need the data tho.
– ChronoBrother
Mar 28 at 0:40
You don’t need to. It’s a one time deal. Access will connect directly to the external data source.
– user9105725
Mar 28 at 0:41
You don’t need to. It’s a one time deal. Access will connect directly to the external data source.
– user9105725
Mar 28 at 0:41
Might be worthwhile microsoft.com/en-us/download/details.aspx?id=54255
– user9105725
Mar 28 at 0:52
Might be worthwhile microsoft.com/en-us/download/details.aspx?id=54255
– user9105725
Mar 28 at 0:52
support.office.com/en-us/article/…
– user9105725
Mar 28 at 1:40
support.office.com/en-us/article/…
– user9105725
Mar 28 at 1:40
|
show 3 more comments
1 Answer
1
active
oldest
votes
Well do you use the access file now with power BI? In ALL and in EVERY case WHEN you use a access data file, you are using a full + standard + legal path name to the access file.
So, if you want users to be able to open the Access accdb file, then the accdb file has to be placed in a folder that is open for use by anyone on the network. So, if you are using power BI with Access now you note that there is a FULL + legal path name to the Access file from that power BI system.
So, if you want to pull data from Access into Excel, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into Word, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into "your whatever application" that is NOW connecting to Access", then the whatever application and the users all need rights to the folder where the Access accDB file resides.
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
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%2f55388444%2fconnecting-power-bi-to-access-database-over-network%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
Well do you use the access file now with power BI? In ALL and in EVERY case WHEN you use a access data file, you are using a full + standard + legal path name to the access file.
So, if you want users to be able to open the Access accdb file, then the accdb file has to be placed in a folder that is open for use by anyone on the network. So, if you are using power BI with Access now you note that there is a FULL + legal path name to the Access file from that power BI system.
So, if you want to pull data from Access into Excel, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into Word, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into "your whatever application" that is NOW connecting to Access", then the whatever application and the users all need rights to the folder where the Access accDB file resides.
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
add a comment |
Well do you use the access file now with power BI? In ALL and in EVERY case WHEN you use a access data file, you are using a full + standard + legal path name to the access file.
So, if you want users to be able to open the Access accdb file, then the accdb file has to be placed in a folder that is open for use by anyone on the network. So, if you are using power BI with Access now you note that there is a FULL + legal path name to the Access file from that power BI system.
So, if you want to pull data from Access into Excel, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into Word, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into "your whatever application" that is NOW connecting to Access", then the whatever application and the users all need rights to the folder where the Access accDB file resides.
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
add a comment |
Well do you use the access file now with power BI? In ALL and in EVERY case WHEN you use a access data file, you are using a full + standard + legal path name to the access file.
So, if you want users to be able to open the Access accdb file, then the accdb file has to be placed in a folder that is open for use by anyone on the network. So, if you are using power BI with Access now you note that there is a FULL + legal path name to the Access file from that power BI system.
So, if you want to pull data from Access into Excel, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into Word, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into "your whatever application" that is NOW connecting to Access", then the whatever application and the users all need rights to the folder where the Access accDB file resides.
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
Well do you use the access file now with power BI? In ALL and in EVERY case WHEN you use a access data file, you are using a full + standard + legal path name to the access file.
So, if you want users to be able to open the Access accdb file, then the accdb file has to be placed in a folder that is open for use by anyone on the network. So, if you are using power BI with Access now you note that there is a FULL + legal path name to the Access file from that power BI system.
So, if you want to pull data from Access into Excel, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into Word, then the Excel user needs to be able to see the accDB file in some folder and have rights to that folder.
So, if you want to pull data from Access into "your whatever application" that is NOW connecting to Access", then the whatever application and the users all need rights to the folder where the Access accDB file resides.
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
answered Mar 28 at 18:52
Albert D. KallalAlbert D. Kallal
17.6k1 gold badge23 silver badges38 bronze badges
17.6k1 gold badge23 silver badges38 bronze badges
add a comment |
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%2f55388444%2fconnecting-power-bi-to-access-database-over-network%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
1
You could use the access options to export to SharePoint or MS SQL Server. There might a little bit of rework on forms or reports, but at that point access is just the front end and you have a backend data source that is more friendly to business intelligence data sharing.
– user9105725
Mar 28 at 0:34
I don’t want to have to export every time I need the data tho.
– ChronoBrother
Mar 28 at 0:40
You don’t need to. It’s a one time deal. Access will connect directly to the external data source.
– user9105725
Mar 28 at 0:41
Might be worthwhile microsoft.com/en-us/download/details.aspx?id=54255
– user9105725
Mar 28 at 0:52
support.office.com/en-us/article/…
– user9105725
Mar 28 at 1:40