PowerBI - Conversion of data stamp powerbi



How to convert time stamp in Power BI

šŸ”€


If you have the problem to get a date and time from  a database that is in Unix time stamp, the better way to use this data is convert in the PowerBI query editor.






Create a new custom column 

Use this command to convert the timestamp in date and time

#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [UnixTime]/1000)



Need to change the format in the column to PowerBI use like a data and time

Change the data and time 


You can use time and date. 






Popular posts from this blog

Remote Server returned '550 5.2.3 RESOLVER.RST.RecipSizeLimit; message too large for this recipient'

Office 365 or Exchange online problem Remote Server returned '550 5.2.3 RESOLVER.RST.RecipSizeLimit; message too large for this recipient' Connect in your office365/Exchangeonlime with PowerShell Confirm the problem,   Get-Mailbox | fl mailboxplan,maxsendsize,maxreceivesize If you have   Get-Mailbox user@mailbox.com | fl mailboxplan,maxsendsize,maxreceivesize MailboxPlan    : ExchangeOnline-1ab122338-4f1a-bac1-c28ff8a1234 MaxSendSize    : 0 B (0 bytes) MaxReceiveSize : 0 B (0 bytes) Execute the command  Set-Mailbox user@mailbox.com -MaxReceiveSi ze 55 MB -MaxSend Size 55 MB  or   Set-Mailbox user@mailbox.com -MaxReceiveSize 150MB -MaxSendSize 150MB To apply for all users run this.  Get-Mailbox | Set-Mailbox -MaxReceiveSize 55MB -MaxSendSize 55MB
Read more

Haproxy error inconsistencies between private key and certificate loaded from PEM file

Error in haproxy with lets encrypt error msg bind *:443' : inconsistencies between private key and certificate loaded from PEM file '/etc/letsencrypt/live/ Need to create a new file cat cert.pem privkey.pem > haproxy_cert.pem Add in haproxy frontend www         bind *:80         bind *:443  ssl crt /etc/letsencrypt/live/mydomain.com/haproxy_cert.pem and make a test haproxy -c -V -f /etc/haproxy/haproxy.cfg
Read more

Porque a centralizaĆ§Ć£o de arquivos?

Image
Porque a centralizaĆ§Ć£o de arquivos?   Muitas empresas gastam boa parte de sua estrutura armazenando a mesma coisa, de forma desorganizada.  Para entender o problema vou tentar explicar de maneira simplificada, como visualizo o problema de gestĆ£o sobre os arquivos e a falta de cultura. E como resolver.
Read more