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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
mmccarthy
Frequent Visitor

Issue connecting to on premise gateway with Sharepoint data sources

I have an issue for the past 4-5 weeks and I have a ticket open with Power BI to resolve. It randomly resolved itself last week but is now an issue again this week. Wondering if anyone else has the same issue.

 

Setup: Postgres database in AWS connecting through ODBC

Initially the issue was only with reports whereby there was a sharepoint or other link used as a datasource in the report. Right now there are also issues with some ODBC (Postgres) data sources.

When publishing a report the option for 'Gateway connection' is turned on with the correct data source listed and it is turned on but the radio button is greyed out and we cannot select the gateway. When looking at the actions list there are red x's beside the data sources, when adding the data sources, the ODBC data source adds fine (although we don't normally need to add this again) and the sharepoint data source has an error. There is no oAuth option there and when using Basic it gives an incorrect credential error. the sharepoint data source is optional to add to the gateway and credentials for all users publishing  reports (of which there all are having this issue) are correct.

 

As of today we now have issues with reports that only have ODBC data source as well

 

anyone else have this issue?

2 REPLIES 2
Greg_Deckler
Community Champion
Community Champion

Hmm, the SharePoint issue has been a reoccurring issue. I used to run into it quite frequently back in the day where the SharePoint connection would simply "forget" its OAuth credentials or OAuth simply wouldn't be available but I haven't seen that in some time so interesting that it returned. 

 

I don't use much ODBC so I can't really speak to that one. 



Follow on LinkedIn
@ 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!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Hi @Greg

 

I don't suppose you've figured out a work around? Its strange, you can come in one morning and check a report that you couldn't connect to a gateway the previous day and all of a sudden you can. But in general for the past 5 weeks its not working and really debilitating. We have basically stopped developing reports as we see there as being no point until this is resolved.

 

Thanks

Michael

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors