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
Issue with Incremental Refresh in Dataflows - Data from Previous Days Getting Deleted
Hello everyone, I have set up two dataflows to create an 8-day data history. The first dataflow (dataflow1) stores data from the past 24 hours and refreshes at 10:30:00 PM, 12:00:00 AM, and 6:00:00 AM. Next, I created a second dataflow (dataflow2) that is linked to dataflow1, and I configured an incremental refresh to retain data from the last 8 days by refreshing data from one day ago. I used a DateTime column for this purpose. Dataflow2 refreshes at 12:30:00 AM, 4:00:00 AM, and 6:00:00 AM. However, I noticed that after 12:00:00 AM each day, the data from the previous day gets deleted in dataflow2, which is not the expected behavior for maintaining an 8-day data history. I would like to understand what might be causing this data deletion and how to correct this configuration to preserve the complete 8-day history without data loss. Thank you in advance for your help!
Incremental refresh with a specific start date for dataset
Hi, I've my report connected to the Oracle Database, I have set up all my RangeStart/End and incremental refresh. I want to only imported dataset starting from 01/01/2023 to YTD - no data from 2022, and I am wondering what and how I should set it up in my incremental refresh setting. I am currently set the archive data starting 3 months from refresh date and incremental refresh 20 days - which will imported my data from 01/01/2023. But by doing it I have to constantly going back to change the setting and refreshing it - this may take up a lot of time everytime I change the setting. I was wondering is there a way we can set a specific start date for import data and they will do the incremental refresh starting from that specific date, in my example is 01/01/2023. Thank you in advance.
Measures different in published report compared to desktop
Some measures seem to be calculating things differently in the published version of a report I have compared to what is appearing locally on desktop. The measures in the desktop version: 22.187%, -1.8350%, 22.594%. The measures in the published report are closer to 14%, -273%, and 54%. The data comes from sql server, which is then unpivoted in Power BI, and the measures are created based on the unpivoted data. Everything seems fine in Desktop, but in the published version I'm seeing very different numbers. Even weirder is I've tried to publish the report a few times and the measure will initially appear correct in the published version and then a few mintues later switch to being incorrect. Any ideas?Important Considerations for Setting up Incremental Refresh on Power BI Desktop
Are you working on big data and want to leverage the powerful capabilities of Power BI desktop? Then Incremental Refresh is a key feature to learn. It makes data refreshes faster and more reliable with less resource consumption.
