general question
18 TopicsFabric compute capacity exceeded its limits. How to know how much CU each dataflowgen2 consumes
Our dataflowgen2 got Failed status after exceeding the Fabric compute capacity limit At the moment, I'm trying to access Fabric Capacity Metrics to see if it can be viewed there but cant open it as well with message "Unable to load model due to reaching capacity limits" - How to know how much CU each activity(dataflowgen2,notebook,etc) in a datapipeline consume so we can avoid hitting the CU limit? - Do we have other way to view fabric capacity metrics?Solved21KViews0likes7Commentsfail to publish jar files to custom libary in Environment
I updated jar files to Enviroment; save was ok too. However I got an error when I tried to publish the files. On the UI it showed "PbiApiError" I checked the browser log it shows "401 access token validation failed" what's the reason here?1.5KViews1like4CommentsLackluster Data Warehouse performance
I am writing this because I am getting fed up with the ill performance of Datawarehouse. Here is my current setup: (External Data such as SQL, Sharepoint, and GA4) => (Dataflow Gen2) => (Data WareHouse) => (Dataset) => (Report) The issue lies with the data warehouse, it is without fail that once or twice a week I have to manually go and click the refresh button on my Dataset that points at the data warehouse because the connection to the warehouse failed or timed out. A simple click of the refresh and it's fine. That would be find except now, the performance on the warehouse just tanked. Now when I try to do a simple select top 1 (seq_no) from Table I tried to let it load for over 30 minutes and no results. I have lost all faith in data warehouses. I have also set up a data lake house in a different workspace and different project. This one is connected to a gen 2, and similar issues in the fact that without fail 1 or 2 times a week I have to go in and click the refresh button on the data set because it is unable to establish connection to the lake house. It works fine after that. For reference: Gateway is (3000.214.8) ( I know there is a new version, waiting on our network teams schedule to have it pushed, but this issue existed prior to the new release) Let me know if you need anymore details or if i should just open a ticket.Solved1.9KViews0likes3CommentsUisng Fabric jupyter notebook to load/push data from/to Snowflake
Hello Farbic Community I'm new to using Fabric and am exploring its capabilities. I understand that we can load data from Snowflake into a Fabric Notebook via Data Lakehouse. I'm curious if it's possible to use a Python script in a Fabric notebook to directly load data from Snowflake into the notebook without involving a data lakehouse. In addition to direct data import from Snowflake, I'm also interested in whether data can be pushed back to Snowflake. If direct data import/export to and from Snowflake isn't feasible with a Python script in a Fabric notebook, is it possible to accomplish this using Dataflow or Data Pipeline? I would appreciate any suggestions and guidance.2KViews0likes4CommentsHandling Timeout Issues with GET Requests in Microsoft Fabric
Hello everyone! I'm facing an issue while trying to download a zip file from a URL using Microsoft Fabric. My goal is to analyze a CSV file contained within this zip using PySpark. However, I'm encountering a timeout error when making GET requests that take more than 172 seconds (2 minutes and 12 seconds). The error I receive in my notebook is as follows: ``` Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f007b0713c0>: Failed to establish a new connection: [Errno 101] Network is unreachable')': /suibase/distribuidorEnergia/creg015_certificados/comer59850_cert3m2024_id85532.sui MaxRetryError: HTTPConnectionPool(host='www.sui.gov.co', port=80): Max retries exceeded with url: /suibase/distribuidorEnergia/creg015_certificados/comer59850_cert3m2024_id85532.sui (Caused by NewConnectionError('<urllib3.connection.HTTPConnection object at 0x7f007b070670>: Failed to establish a new connection: [Errno 101] Network is unreachable')) ``` This error occurs every 2 minutes and 12 seconds, which coincides with the time it takes for the request. Below is the Python code I'm using: ```python url="http://www.sui.gov.co/suibase/distribuidorEnergia/creg015_certificados/comer59850_cert3m2024_id85532.sui" import urllib3 from urllib3.util.timeout import Timeout # Create a PoolManager instance http = urllib3.PoolManager() # Specify connection timeout and read timeout separately connect_timeout = 420 # seconds to establish a connection read_timeout = 540 # seconds to wait for a response # Create a Timeout object with separate values timeout = Timeout(connect=connect_timeout, read=read_timeout) # Make a request with the specified timeout response = http.request('GET', url, timeout=timeout) print(response.status) print(response.data) ``` I would greatly appreciate any suggestions or solutions you can provide to help resolve this issue and successfully download the zip file. Thank you in advance for your assistance!3.9KViews0likes4CommentsAppending Data to existing file in One Lake using APIs
Is it possible to append data to existing json file using One Lake (ADLS) APIs? I have been trying that using the standard ADLS APIs and getting the error - Am I missing something or is it not possible at all to append data to existing fil? The file is inside of a lakehouse.Solved4.1KViews0likes5CommentsIceberg, hudi for Fabric?
As a business user I love the seemlessness of fabric and I realize its potential. User experience is a big deal, and it seems really polished in Fabric. I started digging and asking our architects about our current mesh journey. To my dissapointment it seems that Fabric is locked into delta lake extension of parquet? Is this going to be extended to support Iceberg/Hudi and be cloud store agnostic? This is the answer I got from our architect: Atleast from the data mesh perspective, we are trying to be technology agnostic. Every year, there will always be something new and something trend setting. Datamesh needs to adopt it or incorporate it and continue as an operating model which is not stuck on the tech.Solved7.5KViews1like5CommentsConnect to Lakehouse without MFA
HI Guys, I have a need to connect BrightGauge to Microsoft Lakehouse as an SQL connection. The problem is that BrightGauge cannot handle the modern authentication. Has anyone had luck connecting to a Lakehouse using legacy authentication database username and password?Solved2.1KViews0likes5CommentsFabric DWH unable to refresh
I am trying to refresh the Fabric DWH and getting an error message saying "We couldn't get your warehouse's updated schema. An item with the same key has already been added" Not able to refresh or do anything with it. Keeps showing the same message.Solved2.1KViews0likes6Comments