fabric
12 TopicsHow to load mirriored snowflake data into lakehouse
i have successfully created snowflake mirroring in fabric,but not sure now how to load that data from this mirrored DB in fabric into lakehouse ( i have a snowflake query which will give me desired result,using that i need to load data) so which iteam i can utilized to achive it. if anyone has idea . please share itSolved1.8KViews0likes5CommentsCRM Dataverse integration with Fabric workspace using managed identities in Azure
Team, can we integrate CRM Dataverse environment with the Fabric workspace using managed identities in Azure? Or is there any secure way for integration other than using a user account? If so, can somone please share the guide. Thank you.Solved1.5KViews0likes5CommentsSynapse-Remote extension not working correctly
Hello all, I’m currently losing my mind because off the Synapse-Remote extension not working correctly. When I open a notebook via the extension and try to load cells, I get a message saying that Jupyter is “waiting for the session to be idle.” A few days ago, everything was working fine, but now it’s just stuck loading indefinitely, and nothing happens. I have installed conda, JDK, jupyter lab and jupyter extensions. Oddly, the VS Code web version of fabric notebooks has also stopped working. When I run the notebook inside Fabric, it takes about 2 minutes to connect to the session, but then it eventually works as expected. Has anyone experienced similar issues with Fabric and the Synapse-Remote extension? For context, I’m using a MacBook, but this setup hasn’t been an issue before—even the web version used to work without problems. After loading for 15 mins i got a message that the kernel is dead..1.1KViews0likes3CommentsConnecting ERP to Fabric
I am looking into leveraging Microsoft Fabric to rebuild my data infrastructure which currently involves migrating data from multiple ERPs into an on prem data warehouse. I am finding it difficult to achieve scalability and flexibility. Does anyone know if it is possible to ingest data from an ERP into a lakehouse using Fabric or ADF? If so, is this a feasible way to accomplish this transformation? My goal is to migrate towards a cloud based approach.Solved3.7KViews0likes4CommentsFabric granular permission to use items
My team is running a Fabric POC and we are interested to now about the ability to allow users to create or use Fabric items. For example in Azzure we can allow user to use certain products independently. A data analyst have access to ML studio but not access to Synapse. In Fabric we want to allow some users to use notebooks but not to create pipelines and dataflows. We also want to allow some users to access all items and have the ability to create and edit products. Cheers, Ian2.6KViews0likes8CommentsFabirc Deployment Pipeline fails
The pipeline can only deployed by the owner. IF anybody else tries (They are admin in all workspaces) get the following error. This deployment will overwrite some items in the destination workspace. You must be the owner of any items that will be overwritten. Please check the technical details for more information. If you contact support, please provide these details. From Trouble Shooting Who can deploy content between stages? Content can be deployed to an empty stage or to a stage that contains content. The content must reside on a Fabric capacity. Deploying to an empty stage - Any licensed Fabric user who's a member or admin in the source workspace. Deploying to a stage with content - Any licensed Fabric user who's a member or admin of both workspaces in the source and target deployment stages. Overwriting a semantic model - Deployment overwrites each semantic model that is included in the target stage, even if the semantic model wasn't changed. Any user who's a member or admin of both workspaces, but the tenant admin can restrict this to target semantic model owners only. (What Setting is this?)Solved1.8KViews0likes6CommentsDatawarehose "Explorer -> Queries -> MyQueries -> SQL query X" once created can't delete.
Using Microsoft Fabric - under the "Data Warehouse" experience. Worked on some queries and now I like to clean-up some queries... It turns out that is not possible Once a query is created and used (so is not empty) it can't be deleted. Therefore if you create a query and use it for a while it will have content and if you don't want the query anymore it can't be emptied since it will tell you "Unable to save the query", then if you try to close the Tab it tells you about "Discard changes" or "Cancel" and will revert the changes. If you on the other hand select "Delete" on the specific query in the Explorer it does nothing and the queries just hang there for eternity. I expect that if I delete the query within the Explorer it will be the end-of-it and be removed from the list. Can anyone help?Solved929Views0likes1CommentData Warehouse - Can't delete queries.
Data Warehose "Explorer -> Queries -> MyQueries -> SQL query X" once created can't delete. Using Microsoft Fabric - under the "Data Warehouse" experience. Worked on some queries and now I like to clean-up some queries... It turns out that is not possible Once a query is created and used (so is not empty) it can't be deleted. Therefore if you create a query and use it for a while it will have content and if you don't want the query anymore it can't be emptied since it will tell you "Unable to save the query", then if you try to close the Tab it tells you about "Discard changes" or "Cancel" and will revert the changes. If you on the other hand select "Delete" on the specific query in the Explorer it does nothing and the queries just hang there for eternity. I expect that if I delete the query within the Explorer it will be the end-of-it and be removed from the list. Can anyone help?Solved2.8KViews0likes3CommentsUnable to load complete data in lakehouse
Hi Team, We are trying to load data from a flat file using on-premise data gateway into fabric lakehouse using data flow gen 2. But we are getting only around 54 lakhs + records in the destination table and remaining time the data flow refresh keeps on clocking/refreshing most of the time. When we check the destination, it does not show entire data. Could you please fix the issue or let us know is there any workaround for this.990Views0likes4CommentsAdd new and last modified records to a delta table in Lakehouse Fabric from parquet files
I have some parquet files related to GeneralLedger records in a Lakehouse and I want using pipeline to add only new and last modified records to a Delta table. What should I do? I used combination of lookup activity and copy data, but doesn't work for me. Any idea?2.3KViews0likes4Comments