# PowerBi Reporting

**URL:** <https://community.hubspot.com/t/powerbi-reporting/79438>\
**Category:** Data Hub\
**Created:** [April 17, 2023, 8:25am UTC](https://community.hubspot.com/t/powerbi-reporting/79438 "2023-04-17T08:25:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![IBalta](https://avatars.discourse-cdn.com/v4/letter/i/eb8c5e/32.png) [@IBalta](https://community.hubspot.com/u/IBalta)\
**Post date:** [April 17, 2023, 8:25am UTC](https://community.hubspot.com/t/powerbi-reporting/79438/1 "2023-04-17T08:25:34Z")

</div>

Hi All,

I am trying to pull our data into a PowerBi dashboard, via [datawarehouse.io](http://datawarehouse.io) connector, but I am having troubles seeing the MQLs and the SQLs by month and by brand.

The issue is that there is a low fidelity between the data fields and I cannot match them, could you please advise?

---

<div class="post-metadata">

**Author:** ![johnelmer](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/johnelmer/32/55984_2.png) [@johnelmer](https://community.hubspot.com/u/johnelmer)\
**Post date:** [April 17, 2023, 2:45pm UTC](https://community.hubspot.com/t/powerbi-reporting/79438/2 "2023-04-17T14:45:26Z")

</div>

@IBalta I am asking @GreyHamilton who knows Power BI to see if he can assist.

---

<div class="post-metadata">

**Author:** ![GreyHamilton](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/greyhamilton/32/44643_2.png) [@GreyHamilton](https://community.hubspot.com/u/GreyHamilton)\
**Post date:** [April 17, 2023, 5:56pm UTC](https://community.hubspot.com/t/powerbi-reporting/79438/3 "2023-04-17T17:56:57Z")

</div>

Hey @IBalta,

That should be the hs\_date\_entered\_marketingqualifiedlead and hs\_date\_entered\_salesqualifiedlead fields with the connector.

If you’re using SQL you could get the month a contact entered into MQL or SQL stages with this.

- CONVERT(varchar(7), hs\_date\_entered\_marketingqualifiedlead, 126)
- CONVERT(varchar(7), hs\_date\_entered\_salesqualifiedlead, 126)

You could then group by the brand or use the brand as the breakdown field in your graphs.

If your trying to get the counts of both in one graph you’ll likely need to utilize a PBI custom date table since you’re trying to reference two different dates in one visual.