Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Asif Dakhway]

I’m trying to make report with hourly data pulling from MS SQL database, If I prepare it in Powerbi Desktop it shows correct value but if I publish same report to Powerbi it shows abnormal value. Can anyone help me

Snapshot from Power bi Desktop application

Snapshot from Power bi website

——————————
Asif Dakhway
——————————

[Asif Dakhway]

My DateTime fields 

——————————
Asif Dakhway
——————————
——————————————-

[Ben Howard]

Are you able to share your .pbix file?

——————————
Ben Howard, UK.

Please mark any answer as recommended if it helps you.
——————————
——————————————-

[Bill Kellam]

Is it possible you are looking at another report from the same dataset? Check the lineage of the dataset.

——————————
Bill Kellam
——————————
——————————————-

[Asif Dakhway]

I cannot share the data. lineage is OK

——————————
Asif Dakhway
——————————
——————————————-

[Vishesh Jain]

Hi ,

Can you please check that the dates are being read correctly on PBI Service as I have faced a similar problem and my numbers go haywire.

Instead of a graph try putting the measures on a table with the date and time, this way you can investigate what is actually going on with? the numbers.
I say this because if you look at the Y-axis the numbers are nearly double of what you have on the desktop.

Thank you,

——————————
Vishesh Jain
MCSA Power BI and Excel
Emerald Award Dynamic Communities 2019
Owner
VR Construction
——————————
——————————————-

[Asif Dakhway]

Thanks Vishesh,

I’ll check this and one thing I want to add is I’m using incremental refresh

——————————
Asif Dakhway
——————————
——————————————-

[Vishesh Jain]

Hi ?,

Incremental refresh should not affect this, as it is only related to data refreshes.

My assumption is, that the dates are being read wrong, which is why the numbers are changing and in effect the Y-axis scale too.

Investigate the actual numbers first as this will show if and when, what is wrong where.

Thank you,

——————————
Vishesh Jain
MCSA Power BI and Excel
Emerald Award Dynamic Communities 2019
Owner
VR Construction
——————————
——————————————-

[Asif Dakhway]

I found something strange, I tried report by disabling Incremental refresh, then after publishing to PBI service and refresh from PBI service it shows fine no abnormality
then I enabled the Incremental refresh and after publishing to PBI service and refresh from PBI service it shows again abnormality.

My table is getting updated every hour below is the snap of my incremental refresh

I tried with enabling Detect data changes and Only refresh complete days also but same result

——————————
Asif Dakhway
——————————
——————————————-

[Asif Dakhway]

One more thing 
In both the scenario after publishing report on PBI service it shows normal
It is getting abnormal only when I refresh from PBI service ( After enabling incremental refresh)

——————————
Asif Dakhway
——————————
——————————————-

[Asif Dakhway]

I found the problem
Actually while filtering the dattime  column instead of selecting “is before” I was  selecting “is before or equal to” for RangeEnd option
after correcting, it works fine
Thanks for everybody

——————————
Asif Dakhway
——————————
——————————————-