Forum Discussion
access web app
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
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
Hi which connection are you using and are you simply providing the server/database/user/password that you see in Access Web App?
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