[BUG] Dataflow Gen2 destination picker 404 — api.powerbi.com lakehouses UK region
Hi community, We have a complete blocker with Dataflow Gen2 (CI/CD) destination configuration in our UK-region Fabric tenant. The Error: When clicking "Add default destination" and selecting a Fabric Lakehouse from the OneLake catalog, this error fires immediately for ALL users including the workspace Admin: DataSource.Error: Downstream service call to url 'https://api.powerbi.com/v1/workspaces/{WORKSPACE_ID}/lakehouses' failed with status code 404. (Region: uk) The Lakehouse IS visible in the OneLake catalog — it appears in the picker. The 404 fires the moment it is clicked. Root cause hypothesis: The destination picker calls the legacy Power BI REST API: api.powerbi.com/v1/workspaces/{id}/lakehouses ← returns 404 For Fabric-native workspaces in the UK region, the correct endpoint should be: api.fabric.microsoft.com/v1/workspaces/{id}/lakehouses The OneLake catalog listing (which uses a different path) resolves the lakehouse correctly — it's only the destination configuration call that uses the wrong endpoint. Workarounds attempted — all failed: 1. UI — Admin user attempted same steps → same 404 2. queryMetadata.json via Git — Added destination fields, pushed to prod branch → Fabric silently strips loadEnabled/destination on every sync, creating a permanent conflict loop (workspace ≠ Git on every update) 3. Authentication methods — Before the error began firing immediately, a "Connect to default data destination" screen appeared offering two authentication options for the Lakehouse connection: - Organizational account (Sahil Singh / user account) - Service principal Both were attempted. Neither succeeded — the 404 followed in both cases. Subsequently, this connection credentials screen stopped appearing altogether. The 404 now fires immediately upon clicking lh_dhl_prod in the OneLake catalog, before the connection setup dialog is even shown. This regression suggests the failure point has moved earlier in the destination configuration flow. Questions: 1. Is this a known issue for UK-region tenants? 2. Is there a way to configure the Dataflow Gen2 destination via Fabric REST API directly to bypass the broken UI? 3. Are there other file-based approaches (mashup.pq metadata) for CI/CD Dataflow Gen2 destinations? Happy to provide Session IDs and further details to the Fabric team. I have attached the relevant images, PFA... Thanks
Installing a Data Gateway
I'm trying to connect to a SAP database using Dataflows Gen 2, however it requests an On-premises Data Gateway. I've read a lot about these data gateways. I need to install it on a computer that is ON all the time, which is something that I do not have. I'm assuming that the ideal solution would be to install the gateway on the same machine that is hosting the SAP database? What if I don't have any way of doing this? Is there any solution where Microsoft Fabric can 'host' these data gateways so we don't have to worry about installing in some computers just for the gateway? Thanks in advance
Ms Fabric SAP Hana Connector Issue
Hi all, Background: I have been successful in connecting to SAP BW (hosted in cloud) with Ms Fabric using Dataflow Gen 2 connector. However, I am now working on connecting a SAP HANA Database (hosted by SAP in cloud) with Microsoft Fabric using the Dataflow Gen 2 connector, and have issues configuring the ODBC connector and the Online Power Query connector as follows: 1. ODBC Connector Issue: I have downloaded the ODBC client form SAP development tools and have configured it as follows: However the Test Connection is failing with the following error: 2. Connect to SAP Hana using Dataflow Gen2 Issue: Going forward when I try to connect to SAP Hana using Dataflow Gen2 in MS Fabric after creating a gateway, I get the following error. Error Message: ‘An exception occurred: ODBC: ERROR [08S01] [SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be established because the target computer refused the connection {**.***.***.**:30015} (**.***.***.**:30015)) (Session ID: 16d99661-7b85-41e9-9a4e-2e345c90ce50, Region: germany)’ I currently understand that the Online Power Query error is occurring because the ODBC connection could not be established successfully. Therefore, any help with in resolving the ODBC error and the Dataflow Gen2 error this issue would be highly appreciated. Warm Regards, KartikWe reached the end of the buffer - Dataflow
I have the following dataflow containing : The Entity and the GL/Mapping (I am sharing only screenshots for Entity since the GL/Mapping has the same) are failing to retrieve data when I check them, the sources seems to be pointing to inexisting dataflows : When I check the workspace it is existing but the Dataflow I get this message : The workspace pointing to the dataflow exists but the dataflow is missing but the error message is different : I get this error message : We reached the end of the buffer section Section1; shared #"AFAS Openingsbalans" = let /*#"2018" = let Source = Sql.Database("XXXXXXXXXXX.database.windows.net", "XXXXXXXXXXX"), afas_vw_FinancieleMutaties_Current = Source{[Schema="afas",Item="vw_getAllEmps"]}[Data], #"Filtered Rows" = Table.SelectRows(afas_vw_FinancieleMutaties_Current, each ([Jaar] < 2018) and ([Administratie_code] <> 1) and ([Administratie_code] <> 2) and [Dagboek_code] = "99"), #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Bedrag_saldo", "Verzamelen_op_rekeningnummer"}), #"Grouped rows" = Table.Group(#"Removed Other Columns", {"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Verzamelen_op_rekeningnummer"}, {{"Bedrag_Saldo", each List.Sum([Bedrag_saldo]), type number}}), #"Added Year" = Table.AddColumn(#"Grouped rows", "Year", each 2018), #"Added Period" = Table.AddColumn(#"Added Year", "Period", each 0), #"Renamed columns" = Table.RenameColumns(#"Added Period", {{"Bedrag_Saldo", "Amount"}}) in #"Renamed columns", #"2019" = let Source = Sql.Database("XXXXXXXXXXX.database.windows.net", "XXXXXXXXXXX"), afas_vw_FinancieleMutaties_Current = Source{[Schema="afas",Item="vw_getAllEmps"]}[Data], #"Filtered Rows" = Table.SelectRows(afas_vw_FinancieleMutaties_Current, each ([Jaar] < 2019) and ([Administratie_code] <> 1) and ([Administratie_code] <> 2)), #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Bedrag_saldo", "Verzamelen_op_rekeningnummer"}), #"Grouped rows" = Table.Group(#"Removed Other Columns", {"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Verzamelen_op_rekeningnummer"}, {{"Bedrag_Saldo", each List.Sum([Bedrag_saldo]), type number}}), #"Added Year" = Table.AddColumn(#"Grouped rows", "Year", each 2019), #"Added Period" = Table.AddColumn(#"Added Year", "Period", each 0), #"Renamed columns" = Table.RenameColumns(#"Added Period", {{"Bedrag_Saldo", "Amount"}}) in #"Renamed columns", #"2020" = let Source = Sql.Database("XXXXXXXXXXX.database.windows.net", "XXXXXXXXXXX"), afas_vw_FinancieleMutaties_Current = Source{[Schema="afas",Item="vw_getAllEmps"]}[Data], #"Filtered Rows" = Table.SelectRows(afas_vw_FinancieleMutaties_Current, each ([Jaar] < 2020) and ([Administratie_code] <> 1) and ([Administratie_code] <> 2)), #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Bedrag_saldo", "Verzamelen_op_rekeningnummer"}), #"Grouped rows" = Table.Group(#"Removed Other Columns", {"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Verzamelen_op_rekeningnummer"}, {{"Bedrag_Saldo", each List.Sum([Bedrag_saldo]), type number}}), #"Added Year" = Table.AddColumn(#"Grouped rows", "Year", each 2020), #"Added Period" = Table.AddColumn(#"Added Year", "Period", each 0), #"Renamed columns" = Table.RenameColumns(#"Added Period", {{"Bedrag_Saldo", "Amount"}}) in #"Renamed columns", #"2021" = let Source = Sql.Database("XXXXXXXXXXX.database.windows.net", "XXXXXXXXXXX"), afas_vw_FinancieleMutaties_Current = Source{[Schema="afas",Item="vw_getAllEmps"]}[Data], #"Filtered Rows" = Table.SelectRows(afas_vw_FinancieleMutaties_Current, each ([Jaar] < 2021) and ([Administratie_code] <> 1) and ([Administratie_code] <> 2)), #"Removed Other Columns" = Table.SelectColumns(#"Filtered Rows",{"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Bedrag_saldo", "Verzamelen_op_rekeningnummer"}), #"Grouped rows" = Table.Group(#"Removed Other Columns", {"Administratie_code", "Rekeningnummer", "Rekening_omschrijving", "Verzamelen_op_rekeningnummer"}, {{"Bedrag_Saldo", each List.Sum([Bedrag_saldo]), type number}}), #"Added Year" = Table.AddColumn(#"Grouped rows", "Year", each 2021), #"Added Period" = Table.AddColumn(#"Added Year", "Period", each 0), #"Renamed columns" = Table.RenameColumns(#"Added Period", {{"Bedrag_Saldo", "Amount"}}) in #"Renamed columns", */
