Uploading of dataset Datetime type

DevScope / powerbi-powershell-modules

A collection cmdlets for working with the PowerBI API's

http://devscope.net/

MIT License

192 stars 68 forks source link

Closed saitoh183 closed 7 years ago

saitoh183 commented 8 years ago

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?

saitoh183 commented 8 years ago

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

RuiRomano commented 7 years ago

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