Forum Discussion
Date is shown incorrectly (DirectQuery)
Hello, I have a question about import of Date values. The matter is, we have imported data from Excel in CRM-Table, and then made a report in Power BI with Direct Query (I needed to present both C...
Hi Jolyon,
When connecting to SQL Server database in Power BI desktop, retrieved data are based on the records stored in the database. In your scenario, you need to make sure the data imported from Excel to SQL Server database are correct firstly. You can post a thread in SQL Server Database Engine forum.
By the way, why do you want to get data in DirectQuery mode? You can get data from CRM and Excel at the same .pbix file in Import mode.
Best Regards,
Qiuyun Yu