microsoft / Dynamics-365-for-Marketing---Power-BI-Reporting

Download these Power BI templates to start building custom analytics and reports based on your Dynamics 365 for Marketing data. These templates will help you to connect to your Dynamics 365 instance and access its data. The download includes the following templates: Power BI template for Dynamics 365 for Marketing: Includes the code required to connect to your Dynamics 365 for Marketing data, and also includes functions that you can call to load entity and interaction data with just one line of code. This template provides a basic starting point for building your own custom reports. Sample email marketing analytics report: Provides a comprehensive report of your email marketing results, including detailed analytics, charts, and views spread across multiple report pages. You can use this template as-is, or as inspiration for designing your own reports.
MIT License
47 stars 19 forks source link

Timeout Error When Trying To Load 180 Days In FormsSubmitted Report #7

Open nikolayyordanov opened 4 years ago

nikolayyordanov commented 4 years ago

We get timeout errors on any number bigger than 31. And the data is not that much. But I guess it always downloads the whole blob or parsing the values is taking long. Any ideas how to improve this?

totakac commented 4 years ago

Hi nikolayyordanov, it depends how much data is there in the container. Records are really filtered based on blob last modified date. We are looking in some performance issues right now. Any additional insights will be helpful.

nikolayyordanov commented 4 years ago

Actually, I optimized the filtering and the parsing because it was iterating/downloading all files from the blob storage independent from the date and then filtering. May be this is improved in the latest version of the templates.