I created Lakehouse. In the Lakehouse Files tab I created “New Shortcut”. When I select from file options “Load to Table” it creates Delta Table.
The problem I am facing is add new rows to S3 csv file doesnt refresh the Delta table. I could create View with OPENROWSET and it reflect the changes Live. Is there a way with Table instead?
In Power BI model. How do you handle relationship between DimDate and Fct table that has multiple date attributes (i.e. CreatedOn, ResolutionDate and OrderDate)?
CreatedOn is used in a slicer mainly. The other two dates are part of dax calculations.
Do I make 3 relationships between Fct and DimDate where CreatedOn is Active and Resolution & Order date is Inactive?
If this is the correct approach is it because CreatedOn is used as slicer?
* Solution Verified in a comment *
In Power BI model. How do you handle relationship between DimDate and Fct table that has multiple date attributes (i.e. CreatedOn, ResolutionDate and OrderDate)?
CreatedOn is used in a slicer mainly. The other two dates are part of dax calculations.
Do I make 3 relationships between Fct and DimDate where CreatedOn is Active and Resolution & Order date is Inactive?
If this is the correct approach is it because CreatedOn is used as slicer?
EDIT: Solved. Solution verified. By choosing the most common Date column as active and using USERRELATIONSHIP in dax for other inactive date relationships. Thanks for the answers
My team and I has workspace that integrated with ‘develop’ branch. Currently to create feature branch we click on “Checkout new branch”, it works fine. The issue is when someone make changes on the workspace items then Commit directly to ‘develop’ branch! Is there a way to prevent this?
Something like allow them to create feature branch from “Checkout new branch” but ‘develop’ branch (to avoid direct commit to develop branch). We want to be able to see the changes after being merged to ‘develop’ though, Sync
Sorry for my broken English. Please Help. Thanks!!!
EDIT: Based on the replies I went to “Protect matching branches” tab from settings:
Checked:
Require a pull request before merging
“Do not allow bypassing the above settings”
It should be both
Unckecked “Lock branch” because it made my main branch read-only so even in github I couldnt merge feature branch to develop/main if this option was checked
THANK YOU ALL