Forum Discussion
Dynamics marketing analytics templates reports timeout
Hi Anonymous Thanks for the answer. In my path to the solution, I had applied your recommendations. I'm pretty sure that the problem is more the number of files than the size. I create a new blob storage and copied using ADF only one month of data (~ 600 MB and + 200k files). The size is under 1GB and the report failed refreshing from this new blob too. I ended up copying to a SQL Database the blobs and form that the report refreshed. I think the problem is searching into a blob with this number of files. I understand that search in a blob is more inefficient than in a DB because the data is unstructured and without order criteria but I wonder how is supposed to work the report templates with this architecture using blobs. Maybe I'm missing something. I was hoping this had happened to a lot of people working with these templates.
Hello! Please can you share how do you copy the blob storage to sql server database? We have the same problem with reports with 1 month using Dynamics 365 Marketing. The Power BI reportas take more than 8 hours and don't finish. If you can help us please contact to me by email [email protected]. Thank you!