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

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

rayishome — Fri, 17 Jun 2022 20:12:57 GMT

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: []
}

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

lbendlin — Tue, 21 Jun 2022 01:01:47 GMT

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

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

rayishome — Tue, 21 Jun 2022 13:08:29 GMT

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.

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

Anonymous — Wed, 22 Jun 2022 09:38:49 GMT

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

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

rayishome — Thu, 23 Jun 2022 14:48:04 GMT

I'm not sure I fully understand the steps:

1) Rename the dataset (using the UI) that currently contains the special "/" (renamed using the UI) removing the "/" then use the Post to Group api to post a new file with the "/' included?

2) or, use the API to post the same file without the "/" to see if it posts correctly?

#1, I'm not sure what we will occomplish, the new post will work since it doesn't include the "/"

#2, works!

The issue I'm having is our users expect the use of the "/" using the API via our app since the Service's UI supports the "/".

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

lbendlin — Thu, 23 Jun 2022 15:03:15 GMT

"since the Service's UI supports the "/"

That is a bug in the service. It should not accept that character. You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/