search

ben-howard / PowerBI-Planner

A Power BI template file that imports plans exported from Microsoft Planner
MIT License
43 stars 11 forks source link

Date Formatting Query Errors #9

Open Harker12 opened 1 year ago

Harker12 commented 1 year ago

I am loving this dashboard and have resorted to using this over the power automate pulling directly from teams. I could not identify why my flow continued to create duplicates. My issue currently with this dashboard is the planner exporting and PBI upload date formatting incorrectly. I have tried to change formatting in my PBI settings, the excel prior to uploading into PBI, and formatting inside of PBI after uploading. Nothing seems to be working. I am also having some tasks duplicate inside of PBI but they are not duplicated in the raw data before uploading?? Appreciate any support you can provide. Thanks!!

Query Errors 1 Query Errors 2 Query Errors 3 Duplicates

This is a snip of the raw data for one of the duplicate tasks. Query Errors 3 Duplicates Raw Data

ben-howard commented 1 year ago

Hi,

Thanks for the feedback. You don't mention what date format you currently use and what is being pulled out of Planner, but please review this video https://youtu.be/_AagDlq3BnA for changing the locale of a date. This should fix your issue, but note you'll have to do it in each query which has dates (probably just the task query from memory).

Re the duplicates, to test this, I suggest you remove all the rows from each table in the Excel file and then let the flow run. There should be no duplicates, and then keep a check on this. Note the errors you are showing me on the 2nd image are from 2/3/2023, so either Feb or March depending on your date format; ideally I'd like to see something happening in May :)