Unlink Microsoft Onelake
Hi everyone. I'm facing an issue when I try to unlink my Dataverse Link to Fabric link. I cannot add new tables, cannot unlink, create a new one. When I try to unlink, it shows this: If I go to 'details', it shows this: And if I go to 'manage tables', I face this error: I know that in all these cases I need to contact the support team, but I'd like to give a shot here before. Any guesses of what could be causing that? I tried to link, unlink, I even deleted the workspace and tried to set up in a new one, but it shows that it already exists: "Your tables are already linked with Microsoft Fabric".
"The remote certificate is invalid" error on pipeline Fabric job to copy parquet files from AWS S3
When I try to copy parquet files from AWS S3 bucket with "copy data" job on pipelline function, this error show up: "The file operation is failed. A WebException with status TrustFailure was thrown. The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel. The remote certificate is invalid according to the validation procedure. Activity ID: ******" The test connection results OK. The shortcut function works well too. But we need to copy the data from S3 with pipeline function, the shortcut don't help us. We try with connection type "Amazon S3 Compatible" too and we get the same error. Some one can help or are getting this error too? Thanks!
How do I organize everything?
Hi all, My organisation is on the verge of implementing Fabric, we think it's a great total solution for BI & Analytics. My task is to set up everything, from ADF pipelines to BI reports. Until now we have only used Power BI for our reporting needs. Everything else within Fabric is completely new to us. Here's the situation, like most businesses we are dealing with operational, management, financial and HR data. Currently I have those reports set up in different workspaces, with different people having access to them. Currently we are querying directly on our operational databases. Of course we want to change that and set up our data in the Fabric Cloud. When organizing all of this, what are some best practices regarding data governance in this situation? 1) Should I just set up 1 lakehouse with all the data for the whole tenant, and restrict access to tables/files? 2) Or should I make several data lakehouses (one for each data 'category')? 3) Or should I create several domains with one data lakehouse in each domain? Any insight would be much appreciated.
How to set default Lakehouse in the notebook programmatically?
Hi All, Here are my workspace setup: Workspace Fabric's Artifacts Git branch folder Fabric-Sandbox notebook: landingtoBronze lakehouse: Bronze feature/bronze123 Fabric-Dev notebook: landingtoBronze lakehouse: Bronze Dev Problem: Each time i updated the notebooks code to the Fabric-Dev workspace , i need to attach bronze lakehouse to "landingtoBronze" notebooks manually in the workspace so that it point to the right bronze lakehouse. Please note that each workspace has it own Bronze Lakehouse. For example, I was working in the "landingtoBronze" notebook in my feature branch in the Fabric-sandbox workspace. during the notebook development, I attached the bronze lakehouse of the workspace as default lakehouse to the notebook. once i had finished my notebook development, i created the pull request and merge the code from feature branch into dev branch. while getting the code updated in the Fabric-Dev workspace, I can see the default bronze database is actually referring to the Fabric Sandbox workspace. Is it possible to attach a default lakehouse in the notebook programmactically? Looking forward to hearing for any suggestion. it could be something that i am doing wrongly. Thanks.Direct Lake fallback to Direct Query due to SQL security?
Hi, I am wondering if Direct Lake mode will keep working if I apply granular SQL access control (GRANT, DENY, REVOKE) on a SQL Analytics Endpoint or Data Warehouse? I am also wondering if Direct Lake mode will keep working if I apply SQL Row Level Security on a SQL Analytics Endpoint or Data Warehouse? Thanks! 😀
