How to successfully connect a Microsoft Advertising data source
Please refer to How to connect Microsoft Advertising.
Campaigns and/or metrics are missing
I have connected a source successfully but it retrieves no data
If you have successfully connected a source but Data Explorer shows no data, it means that your account has the right permissions to connect to Microsoft Advertising but lacks the permissions to access that specific campaign. Choose another pair of credentials and try again.
Restrictions with the Goals, Keyword and Product Dimension Report
The Goals, Keyword and Product Dimension report does not support certain campaign types, such as “Shopping”, “Dynamic Search”, or “Audience”, and
Keyword reports do not support ad groups of the type "Dynamic".
Furthermore, the Goals are only attributed to conversion metrics (as seen in What data can I get from Microsoft Advertising), not to other fields e.g. Spend, Clicks, and Impressions.
Paused campaigns may not be visible in Funnel if the report type is less than the "Campaign" level.
Performance Max campaign data not present in non-Campaign reports
Performance Max campaign data is only available via the Campaign report.
Missing Ad Title and Ad Description for Responsive Search Ads or Responsive Ads
Currently, Ad title and Ad description are not available from the Microsoft Advertising reporting API for these types of ads.