Forum Discussion

likensj's avatar
likensj
Frequent Visitor
10 years ago

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...
Need Help
likensj's avatar
likensj
Frequent Visitor
10 years ago

It is microsoft access web app deployed on Sharepoint 365, according to documentation the backend is a SQL database on Azure. Does that help?

 

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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.

  • likensj's avatar
    likensj
    Frequent Visitor
    10 years ago

    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.