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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
amols101
New Member

Auto refresh Dashboard on Power BI online with SharePoint on premise data

Hi,

 

I have a SharePoint 2013 on premise setup and the sites are made available over internet using Azure AD application proxy (which requires OAuth2).

I have created few reports on Power BI desktop by pulling data from SharePoint using using OData service and Windows credentials and published them to Power BI site.

Now I am looking to auto refresh the Data from Power BI site to keep dashborad refreshed all the time, but authentication to SharePoint site fails.

 

The challenge is

1. I can not select OAuth2 to access SharePoint site via AAD app proxy, since it is not supported for OData calls.

2. Widnows credentials does not work since SharePoint site wants to get users authenticated agains AAD and power BI sees that URL as invalid. Please see below images.

PBI1.pngPBI2.png

 

Any help is highly apriciated. Thanks.

 

1 REPLY 1
Greg_Deckler
Super User
Super User

Perhaps the use of a gateway and Windows Auth?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors