New table in existing Power BI dataset ?

[Sylvain2]

I have a small problem with the advanced features of the PowerBI box. I need to push several tables into the same PowerBI dataset.

To do this, I use the ‘table name’ parameter in the connection tab.

The first table passes without a hitch and the dataset is created.

The second table doesn't work. I get the following error:

ERROR: PowerBI API:

Message: Target table ‘<pi>Tableaux</pi>’ was not found in specified dataset ‘sobe_wowvirtualserver|a5f345fb-078e-4319-8160-77b7a9728dc0’



It seems that if the table doesn't exist, we don't know how to create it. Is it possible to create a new table in an existing dataset?

 

[Support]

Apparently, it is not possible to add a table to an existing PowerBI dataset:

https://community.powerbi.com/t5/Po...-existing-Dataset-using-Rest-API/td-p/1087444

https://stackoverflow.com/questions...a-table-in-existing-dataset-power-bi-rest-api

https://community.powerbi.com/t5/Service/API-insert-new-table/m-p/151963


To get around this limitation: Maybe do a big join in Anatella and put everything in a single table? (beware of the limit of 75 columns maximum in a PowerBI table).


Also, just in case Microsoft has suddenly improved their tool, we have added this option to Anatella:



When this option is ticked, Anatella will send the command to create the requested table (even if the table already exists: in fact, there is no way of knowing whether the table already exists or not: another limitation of PowerBI ). As this is a very ‘experimental’ option, it is unchecked at each ‘run’.

This new option has been available in Anatella since v2.7