cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
broekman Regular Visitor
Regular Visitor

gateway connection direct connection not showing

One of our PBIX files that is published to O365 has connections to Excel files. These Excel files are stored in an O365 Modern Group document library. We try to schedule a refresh, but while we normally see in this scenario the option to connect directly to a data source, in this case we only see the option to use a Gateway. For all our other PBIX files that connect to Excel files in an O365 Modern Group we always can connect using a direct connection, Why would that option not show for one of my colleagues? The colleague has a license for Power BI Pro.

6 REPLIES 6
SanderBeukers Regular Visitor
Regular Visitor

Re: gateway connection direct connection not showing

Is your colleague a member of the group?
broekman Regular Visitor
Regular Visitor

Re: gateway connection direct connection not showing

Yes she is.

SanderBeukers Regular Visitor
Regular Visitor

Re: gateway connection direct connection not showing

Just did some tests on my own environment. The only situation in which direct connection is unavailable is when (1 of) the source excel files is/are located outside of the office 365 environment. You could double check that to be sure. Unfortunatly, i cant reproduce your issue for excel files located in a 365 group
broekman Regular Visitor
Regular Visitor

Re: gateway connection direct connection not showing

That is what I thought as well. I will double check and if all Excel files are within O365, I will create a ticket for Microsoft to resolve.

 

Thank you for your help !!

Moderator v-qiuyu-msft
Moderator

Re: gateway connection direct connection not showing

Hi @broekman,

 

Was the issue solved? In your scenario, I guess the the issue can be caused by two factors:

 

1. .PBIX file may retrieve data from local Excel file instead of Office365 document library Excel file.

2. .PBIX file may retrieve data from Office365 document library Excel file and also contains the data source which requires gateway(eg: SQL Server database) at the same time.

 

In your scenario, I would suggest open this specific .PBIX file in desktop, check used data sources in this report.

 

q1.PNG

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

Re: gateway connection direct connection not showing

Hi @broekman,

 

Was the issue solved? Did you check used data sources in the report?

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 241 members 2,892 guests
Please welcome our newest community members: