MarketingAnalyzers - Email.Marketing fails to refresh. The refresh times out (exceeds 2 hours). I have been working with Microsoft and they advised me to submit a new issue here.

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Describe the bug
I'm trying to connect the MarketingAnalyzers.-.Email.Marketing Power BI dashboard to my Marketing instance. However I run into two couple of issues:

1. How can I identify the correct marketing app id? It is a parameter when setting up the connection but it is not documented anywhere.
2. I have tried all available marketing app id's but I still run into this error when connecting to the data store:
   %InteractionTypeIndex
   The parameter is expected to be of type Text.Type or Binary.Type.

Any pointers how to solve this and how to connect the Power BI reports to my Blob Storage?

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?

Hi,

I am getting an error from the EmailClicked table where it appears the Timestamp is invalid.

Seems like the data being added to the table is out of sync with the columns in the table?

Error:

Data in the table (note the values against the columns)

Describe the bug
Hello, I am trying to implement the powerbi model of marketing analyzers downloaded from gibhub, and I can see jouney created, but the table Emailopened and others tables, does not contain data. In dynamics the route or campaign created, by sending an email, which was opened and this is registeredin dynamics in form correct, but not see register in the table EmailOpened.

Please any help

Thank you
Screenshots
If applicable, add screenshots to help explain your problem.

Describe the bug
Customer Journey Scheduling Gantt visualizer generates "Please select a field that is already present in category"

To Reproduce
Steps to reproduce the behavior:

1. Load Email Marketing pbit file.
2. Generate connections in line with documentation
3. Click on marketing plan tab.
4. See error "Please select a field that is already present in category"

Expected behavior
The Customer Journey Scheduling visual should be populated with a Gantt style visualizer showing customer journeys.

Screenshots

Data Connection
Not relevant to the issue.

Additional context
Add any other context about the problem here.

Error message is described in the MAQ Software community (supplier of Gantt chart visualization) below.

https://maqsoftware.zendesk.com/hc/en-us/community/posts/360077235352--Gantt-Chart-Error-message-Please-select-a-field-that-is-already-present-in-category-

Expected result
To be able to connect with external account

To Reproduce
Steps to reproduce the behavior:

1. Set everything according to the article:
   https://docs.microsoft.com/en-us/dynamics365/customer-engagement/marketing/custom-analytics

2. Use external account in the form [email protected]

3. See error

Expected behavior
To be able to connect with Power BI event with external account if it has enough rights

Screenshots

Describe the bug
Three is an extra and non removable data source connection to CDS (https://mktdemospring.crm4.dynamics.com) in the MarketingAnalyzers - Email Marketing.pbit. This causes the data refresh feature to be not available in Power BI service after the report is saved to pbix and published to Power BI service.

A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:

1. Open MarketingAnalyzers - Email Marketing.pbit
2. Wait a new report to be formed (don't save just yet) and fill out parameters
3. Then navigate to File / Option and Settings/Options. Under Current File/Privacy select the option "Ignore Privacy Levels".
4. Save the file locally use for example "MarketingAnalyzers - Email Marketing.pix"
5. Publish to Power BI service My workspace
6. Go to Power BI service My workspace
7. Under Datasets select menu "..." and select "Schedule Refresh" from the row"MarketingAnalyzers - Email Marketing"
8. Notice that there is one extra CDS connection to "https://mktdemospring.crm4.dynamics.com" which cannot be used since it is only demo connection. Notice that this causes the refresh and schedule refresh to be non functioning even thou one is able to use the two other connections (Azure blob connection and CDS connection to one's D365 Marketing)
9. You can check that there is no such connection in the Power BI file by going to back to Power BI Desktop and chancing the data source connections

Expected behavior
I would expect to be able to use both manual refresh and scheduled refresh. And I would expect there would be no extra connection to demo environment.

Screenshots

Data Connection

• CDS connection
• Azure BlobStorage