<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>New board topics in Microsoft Fabric Community</title>
    <link>https://community.fabric.microsoft.com/t5/</link>
    <description>Microsoft Fabric Community</description>
    <pubDate>Wed, 16 Sep 2026 05:41:11 GMT</pubDate>
    <dc:creator>Community</dc:creator>
    <dc:date>2026-09-16T05:41:11Z</dc:date>
    <item>
      <title>Best practice for loading Salesforce data into Fabric with deleted records</title>
      <link>https://community.fabric.microsoft.com/t5/Fabric-platform/Best-practice-for-loading-Salesforce-data-into-Fabric-with/m-p/5367176#M30591</link>
      <description>&lt;P&gt;Hi Fabric Community,&lt;/P&gt;&lt;P&gt;We are currently evaluating the best way to load Salesforce data into a Microsoft Fabric Lakehouse.&lt;/P&gt;&lt;P&gt;We would like to keep the implementation and ongoing operation as low-code as possible, and we are currently considering the following three options:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Dataflow Gen2 + Pipeline&lt;UL&gt;&lt;LI&gt;Use the Salesforce Objects connector in Dataflow Gen2 to retrieve Salesforce data.&lt;/LI&gt;&lt;LI&gt;Load the data into a Lakehouse.&lt;/LI&gt;&lt;LI&gt;Use a Pipeline to run the Dataflow Gen2 on a schedule.&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;LI&gt;Pipeline + Copy Activity&lt;UL&gt;&lt;LI&gt;Use the Salesforce Objects connector directly in a Copy Activity within a Pipeline.&lt;/LI&gt;&lt;LI&gt;Copy Salesforce data directly into the Lakehouse.&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;LI&gt;Copy Job&lt;UL&gt;&lt;LI&gt;Use Salesforce as the source and the Lakehouse as the destination.&lt;/LI&gt;&lt;LI&gt;If necessary, invoke the Copy Job from a Pipeline using a Copy Job Activity.&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;In addition to active Salesforce records, we also need to retrieve records that have been deleted in Salesforce and retain them in the Lakehouse with a deletion flag such as IsDeleted = true, rather than physically removing them from Fabric.&lt;/P&gt;&lt;P&gt;For example, we would like to preserve the Salesforce record state in the Bronze layer as follows:&lt;/P&gt;&lt;DIV class="styles_lia-table-wrapper__h6Xo9 styles_table-responsive__MW0lN"&gt;&lt;table border="1" style="width: 99.9757%; border-width: 1px;"&gt;&lt;tbody&gt;&lt;tr&gt;&lt;td&gt;Id&lt;/td&gt;&lt;td&gt;Name&lt;/td&gt;&lt;td&gt;IsDeleted&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;001&lt;/td&gt;&lt;td&gt;Company A&lt;/td&gt;&lt;td&gt;false&lt;/td&gt;&lt;/tr&gt;&lt;tr&gt;&lt;td&gt;002&lt;/td&gt;&lt;td&gt;Company B&lt;/td&gt;&lt;td&gt;true&lt;/td&gt;&lt;/tr&gt;&lt;/tbody&gt;&lt;/table&gt;&lt;/DIV&gt;&lt;P&gt;We would then update the latest state in the Silver layer using the Salesforce record ID as the key. For downstream use cases such as AI, we would normally use only records where IsDeleted = false.&lt;/P&gt;&lt;P&gt;For this initial implementation, we are not planning to use a watermark-based incremental load. Our current goal is simply to determine the most appropriate ingestion method from Salesforce into Fabric.&lt;/P&gt;&lt;P&gt;My current understanding is that the Salesforce source in Copy Activity provides an "Include deleted objects" option, so option 2 appears to support retrieving deleted Salesforce records.&lt;/P&gt;&lt;P&gt;However, I am not sure how the same requirement should be handled with Dataflow Gen2 or Copy Job.&lt;/P&gt;&lt;P&gt;I would appreciate your advice on the following questions:&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;If we want a low-code implementation and also need to retain deleted Salesforce records in the Lakehouse with an IsDeleted flag, which of the three approaches would you recommend?&lt;/LI&gt;&lt;LI&gt;Can Dataflow Gen2 retrieve deleted Salesforce records in a way equivalent to the "Include deleted objects" option available in Copy Activity? My understanding is that simply selecting the IsDeleted field may not be enough if deleted records are excluded from the Salesforce query itself.&lt;/LI&gt;&lt;LI&gt;With Copy Job, is it possible to retrieve deleted Salesforce records and retain them in the Lakehouse with IsDeleted = true? In this case, I am not asking about detecting deletes through watermark-based incremental loading or CDC. I would like deleted records to be included as part of the Salesforce data retrieval itself.&lt;/LI&gt;&lt;LI&gt;If there is another recommended low-code architecture for loading Salesforce data into a Fabric Lakehouse while retaining deleted records, I would also be interested in hearing about it.&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;If anyone has implemented a similar Salesforce-to-Fabric ingestion pattern in production, or knows the recommended approach in Microsoft Fabric, I would greatly appreciate your experience and advice.&lt;/P&gt;&lt;P&gt;Thank you in advance.&lt;/P&gt;</description>
      <pubDate>Wed, 16 Sep 2026 01:53:21 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Fabric-platform/Best-practice-for-loading-Salesforce-data-into-Fabric-with/m-p/5367176#M30591</guid>
      <dc:creator>RMori95610</dc:creator>
      <dc:date>2026-09-16T01:53:21Z</dc:date>
    </item>
    <item>
      <title>Can a service principal with federated credentials be used for SQL cloud connection auth?</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Engineering/Can-a-service-principal-with-federated-credentials-be-used-for/m-p/5367161#M17961</link>
      <description>&lt;P&gt;Replacing &lt;STRONG&gt;OAuth 2.0 personal-account&lt;/STRONG&gt; auth on our Fabric SQL cloud connections. Workspace identity doesn't fit, because semantic models in other workspaces share the same connection and each workspace has its own identity — those refreshes fail with invalid credentials unless every workspace identity is granted on the database.&lt;/P&gt;&lt;P&gt;A service principal solves that, but I'd like to avoid storing a secret. I added a federated identity credential to the app registration. In the connection settings, Service Principal auth only offers a key or a certificate, with nowhere to reference the federated credential.&lt;/P&gt;&lt;P&gt;Is that expected? I assume federation needs the caller to present a token it already holds, and the Fabric refresh engine has none — so it simply can't apply. Confirmation would be useful, as would any roadmap or Ideas link for secret less cloud connection auth.&lt;/P&gt;&lt;P&gt;If certificate is the answer, I'd also welcome hearing how others handle cert rotation across many connections given the encrypted payload on the update credentials API.\&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 16 Sep 2026 00:00:14 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Engineering/Can-a-service-principal-with-federated-credentials-be-used-for/m-p/5367161#M17961</guid>
      <dc:creator>CharlieFab</dc:creator>
      <dc:date>2026-09-16T00:00:14Z</dc:date>
    </item>
    <item>
      <title>Power BI semantic model refresh fails in Service, but Gen1 dataflow and Desktop refresh successfully</title>
      <link>https://community.fabric.microsoft.com/t5/Power-Query/Power-BI-semantic-model-refresh-fails-in-Service-but-Gen1/m-p/5367160#M159069</link>
      <description>&lt;P&gt;Hi everyone, my semantic model refresh fails in Power BI Service with this error:&lt;/P&gt;&lt;P&gt;DataFormat.Error: The input couldn't be recognized as a valid Excel document.&lt;BR /&gt;Microsoft.Data.Mashup.ErrorCode = 10311.&lt;BR /&gt;The exception was raised by the IDbCommand interface.&lt;/P&gt;&lt;P&gt;However:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;The Gen1 dataflow refreshes successfully.&lt;/LI&gt;&lt;LI&gt;The model also refreshes successfully in Power BI Desktop.&lt;/LI&gt;&lt;LI&gt;I’ve reviewed the Power Query queries and couldn’t find any problems.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;The failure appears to happen only when refreshing the semantic model in Power BI Service. What could cause this difference, and how can I identify the specific query or source triggering the error?&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Error details:&lt;/STRONG&gt;&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;&lt;STRONG&gt;Cluster:&lt;/STRONG&gt; WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Activity ID:&lt;/STRONG&gt; 76273612-20ed-4ca2-988e-4f593db29fa5&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Request ID:&lt;/STRONG&gt; 42e32479-4c91-40cf-b83c-e1ebd9591dc4&lt;/LI&gt;&lt;LI&gt;&lt;STRONG&gt;Time:&lt;/STRONG&gt; 2026-09-15 20:18:51 UTC&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Any help would be appreciated.&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 23:53:57 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Power-Query/Power-BI-semantic-model-refresh-fails-in-Service-but-Gen1/m-p/5367160#M159069</guid>
      <dc:creator>Teddddddddddddd</dc:creator>
      <dc:date>2026-09-15T23:53:57Z</dc:date>
    </item>
    <item>
      <title>Office 365 Outlook activity cannot bind Workspace Identity or Service Principal connection</title>
      <link>https://community.fabric.microsoft.com/t5/Pipelines/Office-365-Outlook-activity-cannot-bind-Workspace-Identity-or/m-p/5367159#M9673</link>
      <description>&lt;P&gt;Hi Fabric Community,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am testing the Office 365 Outlook / Office 365 Email activity in Microsoft Fabric Data Factory for a CI/CD scenario.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;According to the current Microsoft Learn documentation, the Office 365 Outlook activity supports User Authentication OAuth, Workspace Identity WI, and Service Principal SPN.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I tested both Service Principal and Workspace Identity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The Fabric workspace has an active Workspace Identity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The corresponding Microsoft Entra application and service principal exist.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The Office 365 Email / MicrosoftOutlook cloud connection can be created successfully.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The connection is visible in Manage connections and gateways.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;From the pipeline Outlook activity, the connection is also visible through Browse all.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The issue is that when I select the WI or SPN connection from Browse all, Fabric shows the loading indicator but does not bind the connection to the Outlook activity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;No error is displayed.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The problem occurs before pipeline execution, so this is not a Microsoft Graph Mail.Send runtime error.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Expected behavior:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The selected Workspace Identity or Service Principal connection should be associated with the Office 365 Outlook activity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Actual behavior:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The connection is visible and discoverable, but selecting it does nothing and the activity remains without a connection.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This blocks our CI/CD scenario because we want to avoid user OAuth connections that must be recreated or rebound between DEV, TEST and PROD.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I also noticed a documentation inconsistency.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The current Office 365 Outlook activity documentation explicitly says that Workspace Identity and Service Principal are supported.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;However, the general Service Principal support page does not currently list Outlook as a supported data source.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The general Workspace Identity support page also does not list Outlook among the supported data sources.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can Microsoft confirm whether Workspace Identity and Service Principal support for the Office 365 Outlook activity is fully GA, under staged rollout, or currently affected by a known issue?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Microsoft Learn references:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Office 365 Outlook activity&lt;/P&gt;&lt;P&gt;learn.microsoft.com/en-us/fabric/data-factory/outlook-activity&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Service Principal support in Data Factory&lt;/P&gt;&lt;P&gt;learn.microsoft.com/en-us/fabric/data-factory/service-principals&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Workspace Identity support in Data Factory&lt;/P&gt;&lt;P&gt;learn.microsoft.com/en-us/fabric/data-factory/workspace-identity&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I can provide additional diagnostics or tenant details privately if required.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks.&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 23:47:21 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Pipelines/Office-365-Outlook-activity-cannot-bind-Workspace-Identity-or/m-p/5367159#M9673</guid>
      <dc:creator>vicenteajm</dc:creator>
      <dc:date>2026-09-15T23:47:21Z</dc:date>
    </item>
    <item>
      <title>Free Exam Vouchers - DP-600, DP-700 or DP-800</title>
      <link>https://community.fabric.microsoft.com/t5/Microsoft-Fabric-Location/Free-Exam-Vouchers-DP-600-DP-700-or-DP-800/m-p/5367158#M13</link>
      <description>&lt;P&gt;Following up on Haider's Discussion Post:&amp;nbsp;&lt;/P&gt;&lt;P&gt;Free Exam Voucher Interest Form&lt;/P&gt;&lt;P&gt;&lt;A class="lia-external-url" href="https://forms.gle/ErqTGaRw3m43yoYq7" target="_blank"&gt;https://forms.gle/ErqTGaRw3m43yoYq7&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 23:31:20 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Microsoft-Fabric-Location/Free-Exam-Vouchers-DP-600-DP-700-or-DP-800/m-p/5367158#M13</guid>
      <dc:creator>philippaburgess</dc:creator>
      <dc:date>2026-09-15T23:31:20Z</dc:date>
    </item>
    <item>
      <title>Hide a Page within APP</title>
      <link>https://community.fabric.microsoft.com/t5/Desktop/Hide-a-Page-within-APP/m-p/5367152#M1475582</link>
      <description>&lt;P&gt;Hi,&lt;BR /&gt;&lt;BR /&gt;I have two level of users where&lt;BR /&gt;1. set of Users should access page1,2,3&amp;nbsp;&lt;BR /&gt;2. set of Users should access page 1, 2&lt;BR /&gt;&lt;BR /&gt;Any suggestions on how to achieve this without replicating the report in the Power bi App&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 21:24:44 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Desktop/Hide-a-Page-within-APP/m-p/5367152#M1475582</guid>
      <dc:creator>Pooja_Kumar</dc:creator>
      <dc:date>2026-09-15T21:24:44Z</dc:date>
    </item>
    <item>
      <title>Configure Dataflow Gen2</title>
      <link>https://community.fabric.microsoft.com/t5/Dataflow/Configure-Dataflow-Gen2/m-p/5367145#M5840</link>
      <description>&lt;P&gt;Hi,&lt;BR /&gt;&lt;BR /&gt;Using DataFlow Gen2&lt;BR /&gt;I don't see a gear icon anywhere near default destination so I can configure&lt;BR /&gt;&lt;BR /&gt;What am I missing?&lt;BR /&gt;Thanks,&lt;BR /&gt;w&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 20:31:27 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Dataflow/Configure-Dataflow-Gen2/m-p/5367145#M5840</guid>
      <dc:creator>UncleLewis</dc:creator>
      <dc:date>2026-09-15T20:31:27Z</dc:date>
    </item>
    <item>
      <title>RDL Subscription Errors When Saving to SharePoint</title>
      <link>https://community.fabric.microsoft.com/t5/Fabric-platform/RDL-Subscription-Errors-When-Saving-to-SharePoint/m-p/5367144#M30584</link>
      <description>&lt;P&gt;Hi.&lt;/P&gt;&lt;P&gt;I have a paginated report in an app. The app is permissioned to a couple groups of users. Those users can run the report and export the output via the app.&lt;/P&gt;&lt;P&gt;Those users permissioned to the app can also set up a subscription that sends the report output to them via email.&lt;/P&gt;&lt;P&gt;What the users &lt;EM&gt;can't&lt;/EM&gt; do is specify a SharePoint folder in their subscription for the output of the report, even though the same permissions groups on the app have access to the SharePoint site. Here's the error the users get when trying to save the subscription:&lt;/P&gt;&lt;img /&gt;&lt;P&gt;I'm able to specify the SharePoint folder in question and execute a subscription that exports the report output successfully. The only difference between me and the users who only have app-level access to the report is that I'm in a group that has member access to the workspace where the app and report reside. I'm baffled that that difference would prevent users from being able to export to a SharePoint site, but...here we are.&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 20:23:06 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Fabric-platform/RDL-Subscription-Errors-When-Saving-to-SharePoint/m-p/5367144#M30584</guid>
      <dc:creator>MarkPalmberg</dc:creator>
      <dc:date>2026-09-15T20:23:06Z</dc:date>
    </item>
    <item>
      <title>How to display images from Dataverse on Power Bi Report Builder</title>
      <link>https://community.fabric.microsoft.com/t5/Desktop/How-to-display-images-from-Dataverse-on-Power-Bi-Report-Builder/m-p/5367132#M1475581</link>
      <description>&lt;P&gt;Hi all!&lt;BR /&gt;&lt;BR /&gt;On Power BI Report Builder I need to display images I have on Dataverse. What format should they be in? Base64? Also, I should be able to change the images based on the filters I select. Is it possible? Thank you so much&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 19:10:57 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Desktop/How-to-display-images-from-Dataverse-on-Power-Bi-Report-Builder/m-p/5367132#M1475581</guid>
      <dc:creator>Fern_21</dc:creator>
      <dc:date>2026-09-15T19:10:57Z</dc:date>
    </item>
    <item>
      <title>This semantic model uses a deprecated gateway version. Upgrade required.</title>
      <link>https://community.fabric.microsoft.com/t5/Service/This-semantic-model-uses-a-deprecated-gateway-version-Upgrade/m-p/5367089#M302423</link>
      <description>&lt;P&gt;I started getting the following message on nearly every report on my tenant suddenly. The gateway has been updated the same way with the same cadence for years without have this message appear.&lt;/P&gt;&lt;P&gt;The gateway is one update behind the newest. Was able to get the message to go away for most users by restarting the gateway but the message still persists for some. Everything is working fine but as you can imagine, it's causing lots of panic. Any input would be greatly appreciated.&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 16:35:08 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Service/This-semantic-model-uses-a-deprecated-gateway-version-Upgrade/m-p/5367089#M302423</guid>
      <dc:creator>DClark21044</dc:creator>
      <dc:date>2026-09-15T16:35:08Z</dc:date>
    </item>
    <item>
      <title>How can I automatically clear a slicer selection?</title>
      <link>https://community.fabric.microsoft.com/t5/Desktop/How-can-I-automatically-clear-a-slicer-selection/m-p/5367060#M1475574</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;I have a Power BI report page with three dropdown slicers, all configured as single-select. Based on the selections in these slicers, a fourth slicer, displayed as a vertical list, is dynamically filtered to show a list of options from a column in one of my tables.&lt;/P&gt;&lt;P&gt;When I select an option from the vertical slicer, the related information is displayed in several charts and tables.&lt;/P&gt;&lt;P&gt;However, I am experiencing an issue when changing the selections in the three dropdown slicers.&lt;/P&gt;&lt;P&gt;For example:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Suppose I select &lt;STRONG&gt;X&lt;/STRONG&gt; in one of the dropdown slicers. The vertical slicer then displays &lt;STRONG&gt;X1, X2, X3, ...&lt;/STRONG&gt;.&lt;/LI&gt;&lt;LI&gt;I select &lt;STRONG&gt;X1&lt;/STRONG&gt; from the vertical slicer, and the charts and tables update accordingly.&lt;/LI&gt;&lt;LI&gt;Without manually clearing &lt;STRONG&gt;X1&lt;/STRONG&gt;, I change the dropdown selection from &lt;STRONG&gt;X&lt;/STRONG&gt; to &lt;STRONG&gt;Y&lt;/STRONG&gt;.&lt;/LI&gt;&lt;LI&gt;The vertical slicer now displays &lt;STRONG&gt;Y1, Y2, Y3, ...&lt;/STRONG&gt;, but &lt;STRONG&gt;X1 remains selected&lt;/STRONG&gt; in the slicer.&lt;/LI&gt;&lt;LI&gt;Because &lt;STRONG&gt;X1&lt;/STRONG&gt; is not part of the available options under &lt;STRONG&gt;Y&lt;/STRONG&gt;, the charts and tables become empty.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;&lt;STRONG&gt;My question:&lt;/STRONG&gt; Is there a way to automatically clear or reset the selection in the vertical slicer whenever one&lt;/P&gt;&lt;P&gt;of the three dropdown slicers changes?&lt;/P&gt;&lt;P&gt;Ideally, when I change the dropdown selection from &lt;STRONG&gt;X&lt;/STRONG&gt; to &lt;STRONG&gt;Y&lt;/STRONG&gt;, the vertical slicer should automatically clear its previous selection so that I can select an option from the new list (&lt;STRONG&gt;Y1, Y2, Y3, ...&lt;/STRONG&gt;).&lt;/P&gt;&lt;P&gt;I would appreciate any suggestions or recommended approaches. Thank you!&lt;/P&gt;&lt;img /&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 14:57:01 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Desktop/How-can-I-automatically-clear-a-slicer-selection/m-p/5367060#M1475574</guid>
      <dc:creator>Afsaneh25</dc:creator>
      <dc:date>2026-09-15T14:57:01Z</dc:date>
    </item>
    <item>
      <title>Need to Migrate SP written in Synapse to Fabric</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Engineering/Need-to-Migrate-SP-written-in-Synapse-to-Fabric/m-p/5367055#M17954</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;I need to migrate my stored prodecure SP from synapse to Fabric, can you please help me with best approach. I am seeing a lot of syntax changes. Suggest me some best, quickest and efficient ways to migrate.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 14:50:23 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Engineering/Need-to-Migrate-SP-written-in-Synapse-to-Fabric/m-p/5367055#M17954</guid>
      <dc:creator>maxravi</dc:creator>
      <dc:date>2026-09-15T14:50:23Z</dc:date>
    </item>
    <item>
      <title>How can I create  cards with trend percentage and mini sparkline chart like this dashboard?</title>
      <link>https://community.fabric.microsoft.com/t5/Desktop/How-can-I-create-cards-with-trend-percentage-and-mini-sparkline/m-p/5367050#M1475570</link>
      <description>&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;How can I recreate&amp;nbsp; cards with a metric value, MoM growth indicator, and a sparkline trend line inside the same card in Power BI? Is this achievable using native visuals or does it require a custom visual? Screenshot attached for reference&lt;BR /&gt;Requirement:&amp;nbsp;&lt;BR /&gt;1.the card on hover should have glow and shadow ( as shown in screenshot for M365 Groups)&amp;nbsp;&lt;BR /&gt;2.on default the glow and shadow should disappear (as shown in screenshot for Total Mailbox)&lt;/P&gt;&lt;img /&gt;&lt;P&gt;.&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 14:39:29 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Desktop/How-can-I-create-cards-with-trend-percentage-and-mini-sparkline/m-p/5367050#M1475570</guid>
      <dc:creator>Rutvika</dc:creator>
      <dc:date>2026-09-15T14:39:29Z</dc:date>
    </item>
    <item>
      <title>Not able to extract direct lake semantic models through api</title>
      <link>https://community.fabric.microsoft.com/t5/Fabric-platform/Not-able-to-extract-direct-lake-semantic-models-through-api/m-p/5367045#M30577</link>
      <description>&lt;P&gt;I’m trying to retrieve the item definition of a Power BI semantic model using the Fabric REST API, but the request is failing for some semantic models.The API returns the following error:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;RuntimeError: Get Item Definition failed.Dataset Workload failed to export the dataset with dataset id . We cannot load this Direct Lake dataset because your Power BI capacity does not support Direct Lake mode. Please use a Power BI capacity type that supports Direct Lake mode.&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;The semantic model is using Direct Lake mode.&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Is Get Item Definition / Fabric REST API supported for Direct Lake semantic models only when the workspace is on a Fabric-supported capacity?&lt;/LI&gt;&lt;LI&gt;What specific Power BI/Fabric capacity SKUs support Direct Lake?&lt;/LI&gt;&lt;LI&gt;Is there any way to retrieve the semantic model definition/TMDL for a Direct Lake model when the workspace is on a capacity that doesn't support Direct Lake?&lt;/LI&gt;&lt;LI&gt;Could this error also occur if the model was originally created as Direct Lake but the current workspace/capacity configuration has changed?&lt;/LI&gt;&lt;LI&gt;Are there any recommended APIs or alternative approaches for extracting metadata (tables, columns, measures, relationships, etc.) from Direct Lake semantic models in this situation?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;I would especially appreciate clarification on whether this is an API limitation, capacity limitation, or a limitation of the Direct Lake workload itself.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 14:25:56 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Fabric-platform/Not-able-to-extract-direct-lake-semantic-models-through-api/m-p/5367045#M30577</guid>
      <dc:creator>Anmoldeep</dc:creator>
      <dc:date>2026-09-15T14:25:56Z</dc:date>
    </item>
    <item>
      <title>Databricks Mirroring - Direct Lake and Dynamic RLS/ Masking Access Controls</title>
      <link>https://community.fabric.microsoft.com/t5/Service/Databricks-Mirroring-Direct-Lake-and-Dynamic-RLS-Masking-Access/m-p/5367022#M302409</link>
      <description>&lt;P&gt;I want to set access controls for our data in a single place within databricks unity catalogue and have a user's credentials passed back to databricks platform and the relevant data returned on the Power BI report. This seems to works well for direct query but I'd like to ensure that reports are performant for users which may not always be the case using direct query with larger datasets/ models&lt;/P&gt;&lt;P&gt;I've been looking into Direct Lake and have the following questions:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Will we need to set-up databricks/ unity catalogue mirroring with Fabric to enable Direct Lake?&lt;/LI&gt;&lt;LI&gt;Will there be a performance increase using Direct Lake for databricks over Direct Query connections?&lt;/LI&gt;&lt;LI&gt;Will I be able to pass back user's credentials back to source to enforce the masking and RLS set within table access policies in dataricks using a Direct Lake connection?&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;It seems like there are performance benefits to Direct Lake but I am unsure whether RLS and column masking is enforced like Direct Query connections. I don't want to recreate access controls within the Power BI semantic model, ideally.&lt;/P&gt;&lt;P&gt;Can anyone provide the best architecture for working with databricks that is both performant, secure and easy to manage? Is anyone able to provide a practical example of OneLake security and how this applies to mutiple sources and the effect in Power BI? Thanks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 13:59:52 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Service/Databricks-Mirroring-Direct-Lake-and-Dynamic-RLS-Masking-Access/m-p/5367022#M302409</guid>
      <dc:creator>henry_gonsalves</dc:creator>
      <dc:date>2026-09-15T13:59:52Z</dc:date>
    </item>
    <item>
      <title>Paginated reports and direct query live refresh after PBI GWs update to 09/2026 from 12/2025</title>
      <link>https://community.fabric.microsoft.com/t5/Service/Paginated-reports-and-direct-query-live-refresh-after-PBI-GWs/m-p/5367021#M302408</link>
      <description>&lt;P&gt;hello everyone,&lt;/P&gt;&lt;P&gt;This is not a spam. I am Windows server Administrator in Czech Republic. I need your help with this case.&lt;/P&gt;&lt;P&gt;Has someone experinced the same issues? Paginated reports should return the easy results with three records from Oracle table but instead it is still loading and cannot render the report, it should take only few seconds.&amp;nbsp; Refresh of report with direct query live return the screen: (sry it is in the czech language :-(&amp;nbsp; &amp;nbsp; ) First of all, I found out that since May 206, the PBI version includes the built in Oracle ODP provider, so I did disable it in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config, and also tried to change MashupDefaultPoolContainerMaxWorkingSetInMB&amp;nbsp; from 0 to 8192MB(VM Hyper-v server has more), but the paginated reports are still not working at all and direct query too. I have few more hours to try to solve it, then have to recover the virtual machine to the previous deprecated September 2025 version and try to update to March or April 2026, without any changes that probably causes the errors.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you very much community for help.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 13:12:26 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Service/Paginated-reports-and-direct-query-live-refresh-after-PBI-GWs/m-p/5367021#M302408</guid>
      <dc:creator>STANHTPS</dc:creator>
      <dc:date>2026-09-15T13:12:26Z</dc:date>
    </item>
    <item>
      <title>Paginated reports and direct query live refresh after PBI GWs update to 09/2026 from 12/2025</title>
      <link>https://community.fabric.microsoft.com/t5/Service/Paginated-reports-and-direct-query-live-refresh-after-PBI-GWs/m-p/5367015#M302407</link>
      <description>&lt;P&gt;hello everyone,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Has someone experinced the same issues? Paginated reports should return the easy results with three records from Oracle table but instead it is still loading and cannot render the report, it shold take only few seconds.&amp;nbsp; Refresh of report with direct query live return the screen: (sry it is in the czech language&amp;nbsp;:-(&amp;nbsp; &amp;nbsp; ) First of all, I found out that since May 206, the PBI version includes the built in Oracle ODP provider, so I did disable it in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config, and also tried to change MashupDefaultPoolContainerMaxWorkingSetInMB&amp;nbsp; from 0 to 8192MB(VM Hyper-v server has more), but the paginated reports are still not working at all and direct query too. I have fwew more hours to try to solve it, then have to recover the virtual machine to the prevousl deprecated september 2025 version and try to update to march or april 2026, without any changes that probably causes the errors.&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you very much community for help.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;img /&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 12:55:27 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Service/Paginated-reports-and-direct-query-live-refresh-after-PBI-GWs/m-p/5367015#M302407</guid>
      <dc:creator>STANHTPS</dc:creator>
      <dc:date>2026-09-15T12:55:27Z</dc:date>
    </item>
    <item>
      <title>Power bi Refresh Failure</title>
      <link>https://community.fabric.microsoft.com/t5/Service/Power-bi-Refresh-Failure/m-p/5367003#M302405</link>
      <description>&lt;img /&gt;&lt;img /&gt;&lt;P&gt;**Title: Scheduled refresh timing out (5hr XMLA limit) — ServiceNow REST API via Web.Contents, no query folding, incremental refresh not viable**&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Hi all,&lt;BR /&gt;&lt;BR /&gt;I'm hitting a wall with a dataset that pulls from ServiceNow via the Table API and would appreciate any guidance from people who've dealt with non-foldable REST sources at scale.&lt;/P&gt;&lt;P&gt;**Setup**&lt;/P&gt;&lt;P&gt;- Source: ServiceNow Table API (`/api/now/table/incident`, `change_request`, `problem`, `sc_req_item`, `task`, and a custom `u_change_deployment` table) — 6 tables total in one semantic model&lt;/P&gt;&lt;P&gt;- Connector: `Web.Contents` with `sysparm_query`, `sysparm_fields`, `sysparm_limit`, `sysparm_offset` passed through the `Query` record (static base URL, so no dynamic data source issue)&lt;/P&gt;&lt;P&gt;- Paging: `List.Generate` loop, page size 5000, looping until an empty page returns&lt;/P&gt;&lt;P&gt;- Volume: roughly 365,000 incident records for the current year, plus large RITM/task volumes having approx 10 lakh rows and 30 columns&lt;/P&gt;&lt;P&gt;- Capacity: Power BI Pro / shared capacity, North Europe&lt;/P&gt;&lt;P&gt;- Refresh: scheduled daily&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**Problems I'm facing**&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**1. No query folding.** `Web.Contents` isn't foldable, so every transformation (expand record column, type changes, filters) runs locally in the mashup engine after the full payload is pulled. "View Native Query" is greyed out on every step, as expected. I've done what I can by pushing the date filter into `sysparm_query` so ServiceNow returns only the relevant range, but that's manual server-side filtering, not folding.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**2. Incremental refresh flags the query as non-foldable.** The IR dialog shows "Unable to confirm if the M query can be folded. It is not recommended to use incremental refresh with non-foldable queries." I set it up anyway (`RangeStart`/`RangeEnd` as Date/Time parameters, used both in the `sysparm_query` string and in a `Table.SelectRows` step on `sys_created_on`, with "Only refresh complete days" ticked). Settings were: archive 1 year, incrementally refresh last 2 days.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Even with that, refreshes failed. I've since disabled IR entirely to rule it out as the cause, and the timeouts persist — so the bottleneck is the extraction itself, not the partitioning.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**3. Refresh consistently hits the XMLA timeout.** Refresh history shows:&lt;/P&gt;&lt;P&gt;- 3h 25m — Failed&lt;/P&gt;&lt;P&gt;- 4h 23m — Failed&lt;/P&gt;&lt;P&gt;- 5h 0m 5s — Failed (`Data source error: The XML for Analysis request timed out before it was completed. Timeout value: 17999 sec.`)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;After four consecutive failures the service auto-disabled scheduled refresh ("Scheduled refresh has been disabled").&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**4. Dot-walked reference fields appear to be a major cost.** My incident query requests around 35 fields including several dot-walked ones: `caller_id.u_zone`, `caller_id.u_market`, `caller_id.u_region`, `location.full_name`, `assignment_group.u_stream`. These are business-critical for the dashboard so I can't drop them, but each one forces a reference join server-side in ServiceNow, and I'm also using `sysparm_display_value=true` which resolves every reference to its label. I suspect this combination is where most of the five hours goes.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**5. Malformed rows in the API response.** Occasionally ServiceNow returns an empty string in place of a record inside the `result` array, which breaks `Table.ExpandRecordColumn` with "We cannot convert the value "" to type Record". I've worked around it with `List.Select(..., each Value.Is(_, type record))` before building the table, but flagging it in case others hit the same.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**What I've already tried**&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;- Moved all dynamic values into the `Query` record so the data source isn't flagged as dynamic&lt;/P&gt;&lt;P&gt;- Added the mandatory `RangeStart`/`RangeEnd` filter step for IR detection&lt;/P&gt;&lt;P&gt;- Ticked "Only refresh complete days"&lt;/P&gt;&lt;P&gt;- Reduced the incremental window to 2 days&lt;/P&gt;&lt;P&gt;- Disabled IR on the small tables&lt;/P&gt;&lt;P&gt;- Locale-safe datetime parsing instead of hard type conversion&lt;/P&gt;&lt;P&gt;- Null-safe filters throughout&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;None of it got the refresh under the timeout.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;**Questions**&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Has anyone successfully run incremental refresh against a ServiceNow REST source at this volume? Is there a paging or query pattern that performs meaningfully better than a sequential `List.Generate` loop?&lt;/LI&gt;&lt;LI&gt;Is there any way to parallelise page requests in Power Query, or is sequential paging an unavoidable ceiling here?&lt;/LI&gt;&lt;LI&gt;For those who've moved off direct REST extraction — did you go the ServiceNow Database View / scheduled Export Set route, or stage into SQL Server first? Roughly what refresh times did you end up with?&lt;/LI&gt;&lt;LI&gt;Would a Dataflow Gen1 (Pro licence, no Fabric access) realistically help here, given it decouples the extraction from the dataset refresh window but doesn't make the extraction itself faster?&lt;/LI&gt;&lt;LI&gt;Any way to raise or work around the 17999-second XMLA timeout on shared capacity, or is that a hard ceiling?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Happy to share the full M script if useful. Any pointers appreciated.&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 11:51:36 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Service/Power-bi-Refresh-Failure/m-p/5367003#M302405</guid>
      <dc:creator>Rohit_Agrawal</dc:creator>
      <dc:date>2026-09-15T11:51:36Z</dc:date>
    </item>
    <item>
      <title>Is it possible connect via a guest account to a Delta table in a Lakehouse from another tenant.</title>
      <link>https://community.fabric.microsoft.com/t5/Data-Engineering/Is-it-possible-connect-via-a-guest-account-to-a-Delta-table-in-a/m-p/5366990#M17951</link>
      <description>&lt;P&gt;We have the following architecture in Microsoft Fabric:&lt;/P&gt;&lt;LI-CODE lang=""&gt;Open Mirroring Database         ↓ Notebook         ↓ Materialized Delta Tables (Lakehouse)         ↓ Shortcuts into Connection Lakehouse         ↓ Power BI Desktop (Azure Data Lake Storage Gen2 connector)         ↓ DeltaLake.Table()&lt;/LI-CODE&gt;&lt;LI-CODE lang="powerquery"&gt;Source =     AzureStorage.DataLake(         "https://onelake.dfs.fabric.microsoft.com/&amp;lt;workspace-id&amp;gt;/&amp;lt;lakehouse-id&amp;gt;/Tables",         [HierarchicalNavigation = true]     ),  dbo = Source{[Name="dbo"]}[Content], TableName = dbo{[Name="&amp;lt;table_name&amp;gt;"]}[Content], Data = DeltaLake.Table(TableName)&lt;/LI-CODE&gt;&lt;H3&gt;What works&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;Internal users in the hosting tenant can successfully create the connection.&lt;/LI&gt;&lt;LI&gt;At least one external Entra B2B Guest user can successfully create the connection.&lt;/LI&gt;&lt;LI&gt;If we create and publish the semantic model ourselves, external customers can copy/use the model successfully.&lt;/LI&gt;&lt;LI&gt;Existing reports refresh successfully once deployed.&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;What fails&lt;/H3&gt;&lt;P&gt;Several external customer users that have been invited into our tenant as Entra B2B Guests receive a &lt;STRONG&gt;404 error&lt;/STRONG&gt; when attempting to create a new Azure Data Lake Storage Gen2 connection directly from Power BI Desktop.&lt;/P&gt;&lt;P&gt;The users have:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Accepted the guest invitation.&lt;/LI&gt;&lt;LI&gt;Been granted access to the Fabric workspace(Contributor)&lt;/LI&gt;&lt;LI&gt;Been granted access to the Lakehouse.&lt;/LI&gt;&lt;LI&gt;Been added as Guest users in Entra ID.&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;Observations&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;The issue is affecting multiple customers, not just a single user.&lt;/LI&gt;&lt;LI&gt;The same Lakehouse, shortcut tables, and Power Query logic work for other users.&lt;/LI&gt;&lt;LI&gt;A Guest account from one customer tenant works, while Guest accounts from several other customer tenants receive a 404.&lt;/LI&gt;&lt;LI&gt;This suggests the issue may be related to cross-tenant authentication, OneLake access resolution, or the ADLS Gen2 connector rather than permissions on the Fabric artifacts themselves.&lt;/LI&gt;&lt;/UL&gt;&lt;H3&gt;Questions&lt;/H3&gt;&lt;OL&gt;&lt;LI&gt;Are there known limitations or issues with Azure Data Lake Storage Gen2 connections to OneLake for some Entra B2B Guest users?&lt;/LI&gt;&lt;LI&gt;Are there specific cross-tenant access settings, trust settings, or Conditional Access configurations that can cause a 404 during OneLake path resolution?&lt;/LI&gt;&lt;LI&gt;Is there a recommended approach for external customers connecting directly to OneLake Delta tables via the ADLS Gen2 connector?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Any guidance would be appreciated.&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 11:21:00 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Data-Engineering/Is-it-possible-connect-via-a-guest-account-to-a-Delta-table-in-a/m-p/5366990#M17951</guid>
      <dc:creator>FabricEnjoyer</dc:creator>
      <dc:date>2026-09-15T11:21:00Z</dc:date>
    </item>
    <item>
      <title>Intermittent Power BI Service Refresh Failure with Snowflake – wsarecv Connection Reset</title>
      <link>https://community.fabric.microsoft.com/t5/Desktop/Intermittent-Power-BI-Service-Refresh-Failure-with-Snowflake/m-p/5366969#M1475549</link>
      <description>&lt;P&gt;Hi everyone,&lt;/P&gt;&lt;P&gt;We are facing an intermittent issue with &lt;STRONG&gt;Power BI Service semantic model refreshes using the native Snowflake connector through an On-premises Data Gateway cluster&lt;/STRONG&gt;.&lt;/P&gt;&lt;P&gt;The refresh works successfully in &lt;STRONG&gt;Power BI Desktop&lt;/STRONG&gt;, but intermittently fails in Power BI Service.&lt;/P&gt;&lt;P&gt;&lt;STRONG&gt;Error:&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;DM_GWPipeline_Gateway_MashupDataAccessError [snowflake] Get "https://sfc-oh-ds1-109-customer-stage.s3.us-east-2.amazonaws.com/..." read tcp ...:443: wsarecv: An existing connection was forcibly closed by the remote host&lt;/P&gt;&lt;P&gt;The failure occurs while Power BI is downloading the Snowflake query results from the &lt;STRONG&gt;Snowflake-managed AWS S3 stage&lt;/STRONG&gt;. The Snowflake query itself completes successfully.&lt;/P&gt;&lt;H3&gt;What we have confirmed&lt;/H3&gt;&lt;UL&gt;&lt;LI&gt;The issue is intermittent.&lt;/LI&gt;&lt;LI&gt;Retrying the same refresh can succeed without configuration changes.&lt;/LI&gt;&lt;LI&gt;The issue occurs in Power BI Service but not Power BI Desktop.&lt;/LI&gt;&lt;LI&gt;We have a Gateway cluster with &lt;STRONG&gt;two nodes&lt;/STRONG&gt;, and both nodes have experienced the same issue.&lt;/LI&gt;&lt;LI&gt;Other data sources using the same Gateway are not affected.&lt;/LI&gt;&lt;LI&gt;Gateway logs show the connection being reset while accessing the Snowflake S3 stage.&lt;/LI&gt;&lt;LI&gt;The S3 Stage endpoint is reachable on TCP 443.&lt;/LI&gt;&lt;LI&gt;Snowflake authentication and query execution are successful.&lt;/LI&gt;&lt;LI&gt;Microsoft reviewed the Gateway logs and advised that the next investigation should focus on the network path between the Gateway and AWS S3.&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;Microsoft's latest recommendation is to capture the network traffic during a failed refresh to identify which device is sending the TCP reset. They also recommended checking TLS/SSL inspection, firewall/session timeouts, connection limits, and host-based security agents.&lt;/P&gt;&lt;H3&gt;Microsoft recommended testing&lt;/H3&gt;&lt;P&gt;netsh trace start capture=yes tracefile=C:\Temp\gw_s3.etl maxSize=2048 report=disabled&lt;/P&gt;&lt;P&gt;Reproduce the failure and then run:&lt;/P&gt;&lt;P&gt;netsh trace stop&lt;/P&gt;&lt;P&gt;They also recommended running:&lt;/P&gt;&lt;P&gt;SELECT SYSTEM$ALLOWLIST();&lt;/P&gt;&lt;P&gt;in Snowflake and reviewing the Snowflake S3 Stage hosts against TLS/SSL inspection and firewall rules.&lt;/P&gt;&lt;H3&gt;My questions&lt;/H3&gt;&lt;P&gt;Has anyone experienced a similar &lt;STRONG&gt;wsarecv – An existing connection was forcibly closed by the remote host&lt;/STRONG&gt; error when refreshing Snowflake data through the Power BI On-premises Data Gateway?&lt;/P&gt;&lt;OL&gt;&lt;LI&gt;Could this be related to the Gateway's network path to AWS S3 even though TCP 443 connectivity succeeds?&lt;/LI&gt;&lt;LI&gt;Are there any known Power BI Gateway or Snowflake connector issues that can cause this type of mid-transfer connection reset?&lt;/LI&gt;&lt;LI&gt;Are there specific Gateway logs or diagnostics that can identify which component initiated the TCP reset?&lt;/LI&gt;&lt;LI&gt;Has anyone resolved a similar issue by excluding Snowflake S3 Stage endpoints from TLS/SSL inspection?&lt;/LI&gt;&lt;LI&gt;Are there any recommended tests to distinguish between &lt;STRONG&gt;Gateway, firewall/proxy, endpoint security, and AWS/Snowflake&lt;/STRONG&gt; as the source of the reset?&lt;/LI&gt;&lt;/OL&gt;&lt;P&gt;Any guidance or similar experiences would be greatly appreciated.&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Tue, 15 Sep 2026 10:28:53 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Desktop/Intermittent-Power-BI-Service-Refresh-Failure-with-Snowflake/m-p/5366969#M1475549</guid>
      <dc:creator>manoj_0911</dc:creator>
      <dc:date>2026-09-15T10:28:53Z</dc:date>
    </item>
  </channel>
</rss>

