When you have to design multiple partitions it's a good idea to have a partition generator that can create multipe partitions in you project in Vusial Studio. Like you provide a pattern SELECT * FROM FactTable Where PartitionValue = {0} and then {0} is enumerated through the all months of several years, or through whatever partition strategy is.
2 Comments
- Steve_ColemanNew Member
I'm wanting a partition manager in PBI Desktop.
- fbcideas_migusrNew MemberStatus added:New
Recent ideas
Allow Detect Data Changes for Historic Data Outside Incremental Window
In Power BI Incremental Refresh,Detect Data Changes only works inside the incremental refresh window. If historic data gets updated, Power BI cannot detect or refresh it unless I expand the increment...NAGAKEERTHI_Y4 hours agoNew MemberNew119Views1like1CommentEnable sorting of diagram pages in Power BI Desktop
I, as a developper, rely a lot on model view and diagrams... It's annoying to not be able to sort the diagram pages in this view, since I tend to try to organize these by subject and it becomes a...Daproulx4 hours agoFrequent VisitorNew10Views0likes0Comments