Incremental Refresh with Dataverse
Hi!! Im wrtiting today in order to know if Incremental refresh works with Dataverse? The issue is because ive been trying to apply incremental refresh to some .xlsx files inside a sgarepoint folder without success. So before giving to my customers the option of taking the data into an SQL Database, I was wondering if they can do it through connecting the sharepoint to the dataverse and then apply the Incremental Refresh to the Dataverse as a source. Haven´t found any info about it and dont really know how to dataverse works so if you can help me it will be a big help. Thanks & Regards
Validate from Fabric whether the file exists
I'm working on Fabric, and I need to load data from an on-premise folder (A) to another on-premise folder (B) or alternatively to a lakehouse (C). The loading process depends on whether the file (X) has been created or not in the original on-premise folder (A). How can I validate from Fabric whether the file (X) exists or not before triggering the loading execution?Percent usage in matrix type table in Power BI.
I am in doubt as to how to perform percentages when I go to the next level of drill down in my matrix, the first line was ok, but when I go down the level, 100% is displayed in all data. My base formula is: Total Sales Underline = CALCULATE([Sale Qty Weight KG], ALLSELECTED('Item'[Underline - Name])) % Share Underlines = DIVIDE([Sales Qty Weight KG], [Total Sales Underlines]) but there are other levels that need the percentage. Can someone help me? how I use the other lines, like: Item [Group - Name] Item - Description [Description]
