im new to Power BI. I have the following problem:
I use Direct Query to Connect to SQL Database. The Databasse contains 15 Instruments with the following information:
ID of Device
Datetime in Decimal of Taken Value
Timstamp in Integer
I nedd to cut of the Seconds in Order to Display the Values (if the secends differ the tooltip will not Display the values of all 15 instruments)
Change to Import is not an option. i already realised this scenario, is working fine. But i need the newst data if the customer opens the Dashboard. I cant use Split, Trunc, and several other Methods because they are not supported in direct query.
I can change the View or how the Data is stored in the Database. But i would like to have a solution in Power BI without the change of the Database.
Any tips, tricks ideas would be appreciated.
Kind regards Armin
Solved! Go to Solution.
i have this problem: new power BI says there is data 2 days in the future.
This is impossible. There can only be data until the current day. Because every hour there will be a measurement.
and there is no error in the database
any ideas why this occurs?