Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
pmi
New Member

access web app

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

1 ACCEPTED SOLUTION
pmi
New Member

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

View solution in original post

3 REPLIES 3
pmi
New Member

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
Not applicable

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

Anonymous
Not applicable

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors