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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors