Forum Discussion

ToshikiHata's avatar
ToshikiHata
Regular Visitor
10 years ago

REST API don't work correctly(Update an existing table scheme)

I'm writing php script which contain PowerBI REST API call.

 

And it seems that "Add Rows to a table in a dataset" API and "Update an existing table scheme" API don't work correctly.

 

Operation and Result which I take are as below.
If someone know about this matter, please help me...

 

<Operation>
1. Prepare Dataset which contain real data.
2. Call "Update an existing table scheme" API, and Add new columns.
3. Call "Add Rows to a table in a dataset" API, and Add data. Additional data contain new columns value.

 

<Result>
・All api call return status code 200 OK.
・But Power BI result was incorrect.
・New data are added.
・But new column values are invisible.

 

<Example>
Describe example below.

 

1. Prepare Dataset as below
'id' 'val1'
001 'aaa'
002 'iii

 

2. Call api and update table definition as below.
'id' 'val1' 'val2'

 

3. Call api and add data as below.
'id' 'val1' 'val2'
003 'uuu' 'eee'
004 'ooo' 'kkk'

 

4. Sign in PowerBI web. And dataset's status is below.
('val2' column is invisible.)
'id' 'val1'
001 'aaa'
002 'iii
003 'uuu'
004 'ooo'

 

<Reference>

PowerBI web specification is below.
http://docs.powerbi.apiary.io/#

No RepliesBe the first to reply