Forum Discussion
Connecting Power BI Desktop to access web data-Which one do I use?
Again probably a really simple question, We recently began migrating several excel files into access web and I have turned on the read/write capabilities to access the database, however when I tr...
likensj Yeah. It helps me know I won't be the best resource to assist :) My intiial guess is that you will need to access this via SharePoint or something else. Unless this is a different scenerio, you most likely don't have access to the database. I relate this to my experiance with CRM online - do they use Azure SQL on the backend? - yes, do I have access directly to the database? No. I have to use CRM connector, or pull it down behind the scene's using a 3rd party tool. Sorry I couldn't be more help.
Well thank you anyways-That was what I was wondering. According to the access documentation I can connect to these data sets. I am honestly learning as I am going so-Perhaps someone else can shed some light on the subject. -Thanks again.