Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Estou trabalhando com uma base de dados com KPI's em horas, na minha pasta de trabalho no excel os dados são colocados em data/hora tipo:
-Exemplo:
01/01/1900 00:30:00
Ao subir a informação no Power Bi, as novas informações inseridas estão dando erro.
Na pasta de trabalho ao colocar à hora do resultado controlado eu apenas digito à hora que automaticamente a planilha escolhe essa data generica "01/01/1900" o que pra mim tanto faz, já que ao subir no Power Query do Power Bi a coluna está formatado em horas e só extrai a hora que irei trabalhar no Power BI.
Solved! Go to Solution.
Hi @marcloap_jr ,
How do you want the time column to appear when importing into Power BI?
Will converting this column to a Time type in Power Query satisfy the requirement?
Or do you want to convert this column to decimal time? You can add custom columns in PQ:
= Duration.TotalHours([Time]-#datetime(1900,1,1,0,0,0))
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @marcloap_jr ,
How do you want the time column to appear when importing into Power BI?
Will converting this column to a Time type in Power Query satisfy the requirement?
Or do you want to convert this column to decimal time? You can add custom columns in PQ:
= Duration.TotalHours([Time]-#datetime(1900,1,1,0,0,0))
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data