Forum Discussion

pmi's avatar
pmi
New Member
10 years ago
Solved

access web app

Does Power BI support Access Web Apps in Office365/Sharepoint Online?

  • pmi's avatar
    pmi
    10 years ago

    Solved!

     

    I wasn't aware that the Access Web App stores the  DB as SQL DB to Azure.

     

    With the read-only credentials and server url from Access (external access) it is possible to connect directly from Power BI via SQL connector.

     

    Here the link to Microsoft

    Access App External Connections

3 Replies

  • pmi's avatar
    pmi
    New Member
    10 years ago

    Solved!

     

    I wasn't aware that the Access Web App stores the  DB as SQL DB to Azure.

     

    With the read-only credentials and server url from Access (external access) it is possible to connect directly from Power BI via SQL connector.

     

    Here the link to Microsoft

    Access App External Connections

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi which connection are you using and are you simply providing the server/database/user/password that you see in Access Web App?

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Which connection do you select and which credentials are used. I can get them from Access Web App, do i supply all the info or use my login info from sharepoint 365 account