We help IT Professionals succeed at work.

Access Database in One Drive for Power BI desktop

GEMINI-INDIA
GEMINI-INDIA asked
on
High Priority
108 Views
Last Modified: 2018-08-26
Dear Experts team,

Have spent sometime and unable to find solution for the following 2 questions

1. How to connect Access Database in One Drive from Power BI desktop?
2. How to connect Power BI Services to One Drive Access database for scheduled refresh?

Appreciate your guidance.
Comment
Watch Question

Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014
Commented:
You don't use One Drive with Access. One Drive is a file sharing service.

Download the Access database from One Drive onto your local machine and use it from there.
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
I very much agree with Scott. Databases (Access, QuickBooks et al) should be local or on a terminal server for remote access. You can sync your database back to One Drive when done if you wish.
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
As suggested, you can't use Access with One Drive in this manner.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.