Forum Discussion
Difference between Dynamics 365 and Azure SQL data
Anonymous - OK, whew! I thought maybe the world had gone crazy there for a second. I haven't heard of anyone getting access to Dynamics 365 base SQL tables. Well, the first thing I would check would be to check the time zone settings for your Dynamics 365 instance and your Azure SQL Server instance and, heck, your Power BI instance for good meausre. Make sure they are all the same. I suppose that having different time zones could affect this kind of thing. The only other thing I can think of is if there is a difference in the base dates used by Dynamics 365 and Azure SQL Database but I can't imagine that is the case. There is a difference in the base reference date between SQL Server and Power BI. Power BI is midnight Dec 30 1899 if I recall correctly. I believe SQL Server is 1/1/1900
Anonymous - OK, whew! I thought maybe the world had gone crazy there for a second. I haven't heard of anyone getting access to Dynamics 365 base SQL tables. Well, the first thing I would check would be to check the time zone settings for your Dynamics 365 instance and your Azure SQL Server instance and, heck, your Power BI instance for good meausre. Make sure they are all the same. I suppose that having different time zones could affect this kind of thing. The only other thing I can think of is if there is a difference in the base dates used by Dynamics 365 and Azure SQL Database but I can't imagine that is the case. There is a difference in the base reference date between SQL Server and Power BI. Power BI is midnight Dec 30 1899 if I recall correctly. I believe SQL Server is 1/1/1900
My apologies for the delayed response! Since I'm new to this forum I had some trouble logging in..
Thank you very much for your quick answer, I'm going to contact our chief IT-manager with this information and hopefully we'll manage to fix it. Since the end of the year is approaching, he doesn't seem to be in office as soon as begin january.
I'll keep you updated! Thanks!