Forum Discussion

rayishome's avatar
rayishome
Resolver I
4 years ago

PowerBI-Post-Import-In-Group API cuts off the name when creating the dataset

Using the following API call and uploading a PBIX file the dataset the service creates removes some of the string values.  

 

url https://api.powerbi.com/v1.0/myorg/groups/[worksapce]/imports?datasetDisplayName=Test%209%2F5%2F2022.2.3.4.5.5.6.6.%23..P.pbix&nameConflict=Abort&skipReport=true

 

Results in the following status:

 

res {
'@odata.context': 'http://wabi-us-east2-redirect.analysis.windows.net/v1.0/myorg/groups/[workspace]/$metadata#imports/$entity',
id: 'id value removed',
importState: 'Succeeded',
createdDateTime: '2022-06-17T19:53:46.733Z',
updatedDateTime: '2022-06-17T19:53:46.733Z',
name: 'Test 9/5/2022.2.3.4.5.5.6.6.#..P.pbix',
connectionType: 'import',
source: 'Upload',
datasets: [
{
id: 'id removed',
name: '2022.2.3.4.5.5.6.6.#..P',
webUrl: 'https://app.powerbi.com/groups/[workspace]/datasets/[new dataset id removed]',
targetStorageMode: 'Unknown',
upstreamDatasets: [],
users: []
}
],
reports: [],
dataflows: []
}

 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Forward slashes / are reserved characters and cannot be used in file names.

    • rayishome's avatar
      rayishome
      Resolver I
      4 years ago

      Thanks for the reply.  I'm not sure that's the issue, but it would make sense if the API developer built that validation into the process.  The service allows the "/" when a dataset is renamed which would make this api validation inconsistant with user experience.  

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi rayishome ,

        Could you please try to rename the pbix file without the special characters "/" and recall that REST API Imports - Post Import In Group? Later check if it can create the content in the specific workspace successfully...

        Best Regards