"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!
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! 😀
Help Making Sense of Capacity Units in the Fabric Capacity Metrics report
Greetings, community. I am trying to evaluate the Fabric usage in our organization in relation to Microsoft's new pricing announcement. I am using the Fabric Capacity metrics report but am finding it less-than-helpful in terms of connecting the data provided to Fabric Capacity Units. We have a Power BI Premium P1 SKU with F64. The report shows everything in Capacity Units in Seconds: CU (s) Our total CU usage is show as <10%. My question is: does that 10% translate to 10% of the 64 CU included with our P1 plan? The report doesn't explicitly identify the actual number of capacity units in use and/or used. I read the documentation for the report, which didn't really clarify either.
Not able to save CTE as Table or View
Hello Everyone, I have created a CTE as follows; WITH cte as ( SELECT Month_Name, Month_Number, Project_Category, 100.0 * Actual_Hours / NULLIF(SUM(Actual_Hours) OVER (PARTITION BY Month_Name, Month_Number), 0) AS Percentage FROM [DW_MonthlyReport].[dbo].[TimelogByType] --GROUP by Month_Name,Month_Number,Project_Category ) select cte.Month_Name, cte.Month_Number, cte.Project_Category,Sum(cte.Percentage) AS Percentage from cte GROUP by cte.Month_Name,cte.Month_Number,cte.Project_Category; When I'm trying to save it as View of Table. I'm getting this error; What I'm doing wrong Please tell.How to facilitate this security requirement in Fabric?
Looking for some ideas/best practices on how to achieve some sort of row level security for non-viewer roles in OneLake. Background: Certain confidential HR and financial data should not be visible to the creators of the Power BI reports for example, but available through row-level-security for the viewers of the report. Is this possible through the new One-Lake architecture in Fabric? How would I have to set this up?
Using Deployment Pipelines with Warehouses
Hi, there seems to be an issue, when I set up a deplyoment pipeline with Test and Production and assign Test and Production workspaces to it, the deployment pipeline stages are always out of sync when trying to deploy a warehouse. I have a warehouse in the test workspaces and even if I delete the prod one and try to redeploy the test warehouse, it deploys succesfully but pipeline afterwards shows out of sync as "Different". If I click review changes we can see that it always will be out of sync as it has "Z" next to it after all the timestamps, which is basically Zero timezone. This is very weird behavior as I would expect it to be 1:1 after deleting it and redeploying.
