Forum Discussion
Doubled values for all Januarys!
I have a SQL View that sends General Ledger entries to a Power BI Dataset, and I have a basic Calendar table connected to the resulting table.
Today I have noticed that the separate Report that's live connected to the published Dataset shows exactly double the value that it should for any January in any year. The SQL View's not sending double the rows, the table in my Dataset PBIX doesn't have double the rows, but as soon as it's published any Report connected to it shows a doubled value in all the 'January's'.
I did an "Analyse in Excel" and pulled back the rows of data, and it shows that there are double the rows for January in the Dataset residing in the Service.
I can see nothing wrong in my SQL, PowerQuery, my data model or my DAX calculations that would cause such a weirld niche issue. Is this some known bug that others have experienced?
Hi leesm1thy ,
I still could not reproduce your problem until now...It may be related to the environment, account number and many other factors.
From your description, it seems like a temporary issue and since it has been resolved after rebuilding.
I'm so sorry for not helping you...
Could you please mark the answer to make this issue completed?
Have a nice day~
Best Regards,
Eyelyn Qin
3 Replies
This isn't urgent, because after a few attempts to refresh the Dataset and re-publish it, the issue seems to have resolved itself. But it's lost me some confidence in the user community - especially as I can't explain how it happened.
Hi leesm1thy ,
I still could not reproduce your problem until now...It may be related to the environment, account number and many other factors.
From your description, it seems like a temporary issue and since it has been resolved after rebuilding.
I'm so sorry for not helping you...
Could you please mark the answer to make this issue completed?
Have a nice day~
Best Regards,
Eyelyn QinAppreciate you looking in to this.
