Uploading of dataset Datetime type

Question

saitoh183 opened this issue 9 years ago · 2 comments

When i use Out-PowerBI to upload the result for the column that are set to datetime cannot be used in Hierarchy (by month, yeah, etc)

When i upload the CVS of the same dataset using GetData from PowerBi, i get the options. (same In PowerBi Desktop)

using Out-PowerBI:

Using GetData

I also tried using Out-PowerBi with the CSV and its the same problem.

Is this a limitation or there is something im missing?

Answer 1 · 2016-03-10T20:57:16.000Z

if it can help, here is my CSV
AllRequestTable..txt

Answer 2 · 2016-06-17T10:18:38.000Z

Hi,

You are right, but it seems to be a limitation on the PowerBI API, please open a UserVoice request here:

As an alternative you could create those columns in powershell and upload them with out-powerbi, ex:

Import-Csv $file.FullName | select @{Label="Year";Expression={$_.Closed.Year}}, *

Thanks