data refresh
1 TopicAzure 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.4.4KViews0likes1Comment