Date not working after appending queries of two types (Google Sheets + Analytics API)

[DanielBI]

Hey guys,

I am working on a dashboard for our marketing data that should show marketing spent, leads, cost per lead and more.

For the marketing spent data I have two sources:

1."Old" -  A google sheets containing older adwords campaign costs 

2."Live" -  A google Analytics query using the built in PowerBI Analytics Datasource for 2017 campaign costs

Both have the same layout, including columns like "Date","Costs","Clicks". When I use them seperately to build a report, the date hierarchy is shown immediately once I pull the "Date" column into the Axis field. When I append the "Live" Query to the "Old" Query however and try the same thing, the date won't work properly.

Is there a step I am missing? Any common pitfalls I do not see?

Appreciate your help!

[Eric_Zhang]

---

@DanielBI wrote:

Hey guys,

I am working on a dashboard for our marketing data that should show marketing spent, leads, cost per lead and more.

For the marketing spent data I have two sources:

1."Old" -  A google sheets containing older adwords campaign costs 

2."Live" -  A google Analytics query using the built in PowerBI Analytics Datasource for 2017 campaign costs

Both have the same layout, including columns like "Date","Costs","Clicks". When I use them seperately to build a report, the date hierarchy is shown immediately once I pull the "Date" column into the Axis field. When I append the "Live" Query to the "Old" Query however and try the same thing, the date won't work properly.

Is there a step I am missing? Any common pitfalls I do not see?

Appreciate your help!

---

@DanielBI

Could you share the problematic pbix in your case?

[DanielBI]

I saw the same happening right now when I connected two tables ("DealSchedule" and "Revenue Execution Targets"). I connected the tables using a "Date Table" in the middle. Once I added the connection, I was not able to use the "Date" column of my "DealSchedule" table as a date hierarchy anymore. Any insight into why this is happening?