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