SQL Table refresh
Hello Community, need your help on this ( i am not able to attach files so pasting a sample of table) I have a table as per the below structure Run Date Region Manager supplier part spend 10-Mar-23 Region3 Manager3 Suppr2 Part3 18891 10-Mar-23 Region1 Manager1 Suppr2 Part3 10824 10-Mar-23 Region3 Manager2 Suppr3 Part2 14979 10-Mar-23 Region3 Manager2 Suppr1 Part3 15868 10-Mar-23 Region1 Manager2 Suppr3 Part3 15111 10-Mar-23 Region1 Manager2 Suppr1 Part2 19506 my organization does not grant create table access on the server so workaround is to dump the above table into Access DB which i will use to create reports in Power BI. The ask here is the owner of this table will refresh spend values for the existing dataset without altering the table structure and append data only in case a new region or a new manager or a new supplier has sent the data every before fiscal month run. the april run month table is now like this(Red ones are the new data received) Run Date Region Manager supplier part spend 10-Apr-23 Region3 Manager3 Suppr2 Part3 77036 10-Apr-23 Region1 Manager1 Suppr2 Part3 366771 10-Apr-23 Region3 Manager2 Suppr3 Part2 100775 10-Apr-23 Region3 Manager2 Suppr1 Part3 434291 10-Apr-23 Region1 Manager2 Suppr3 Part3 169688 10-Apr-23 Region1 Manager2 Suppr1 Part2 75593 10-Apr-23 Region 2 Manager4 Suppr1 Part2 340684 10-Apr-23 Region 2 Manager4 Suppr4 Part4 253959 10-Apr-23 Region 2 Manager1 Suppr4 part1 341101 10-Apr-23 Region 4 Manager2 Suppr2 Part5 28213 10-Apr-23 Region 4 Manager3 Suppr3 part1 42718 what i need is there should be some way to keep the old data table in access and a new column/table is added as per run date so that i can substract values from previous run to current run and check which region > manager> supplier> part has shown a high variance.
Azure Analysis Services - refresh
Hello, our current setup is on-premises PostgreSQL DB that serves as data warehouse. We use Power BI Pro platform to create data model and refresh the data daily, using locally run Data Gateway. As the size of the data is already resulting in refresh times longer than 1 hour, and getting close to the 1GB data model size limit, I am considering setting up Azure Analysis Services. However, what is not clear to me is how the data refresh is handled in such case. I presume that on-premises data gateway would still be required in order to access our PostgreSQL DB. How is the refresh (and in addition, incremental refresh) handled when using Azure Analysis Services? Is there a scheduler available? Are there some limitations (e.g. how long a refresh can take before it timeouts?) Thank you.