Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In Power BI Desktop I have a Power Query that pulls LocationDim from SQL Server and another Query that pulls a list of locations from an Excel file. Both queries load to the data model. I can publish this model & have both tables refresh via an On Premise Data Gateway. However, if I modify the LocationDim query & perform a Merge function (inner join to filter LocationDim by the locations in the Excel list), this model cannot be refreshed by the Data Gateway. Instead on the Power BI / Refresh Schedule page it tells me that I need to install a Data Gateway for the data sources specified in the model.
Does the Data Gateway not support mixing data from two different sources defined in the Gateway?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.