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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
BBIUser
Helper IV
Helper IV

Questions related to Data Gateway for Data Source containing merged SQL Server and Excel file

Hi,

 

I have a report with 1 excel dataset merged with another excel and 1 SQL Server data source. 2 excels are in SharePoint and SQL is on-premises.

I am aware this scenario will work only when " Allow user's cloud data sources to refresh through this gateway cluster" is applied in the Gateway Cluster Settings.

https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud

I have not applied this option in our company for security reasons.

 

1) Is there any other possible solutions out there, so that the Gateway will work when these types of merges are used for the reports? - does it work when the Composite Model is used?

OR

2) My only solution is to load the excel to SQL and then connect to the SQL?

 

Apperciate your thoughts!

1 REPLY 1
GilbertQ
Super User
Super User

Hi there

As far as I know currently you would either need to enable the option on the Gateway.

Or load it all into SQL Server.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors