Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I'm trying to load a many large csv file into powerbi automatically, and to so i've automate the creation of datasets.
However when i try to add rows of data to the dataset in this fashion it simply crashes::
`Add-PowerBIRow -DataSetId $dataset1.Id -TableName $table1.name -Rows (Import-Csv -Path ".\data.csv") `
as seen here :: https://docs.microsoft.com/en-us/powershell/module/microsoftpowerbimgmt.data/add-powerbirow?view=pow...
if I try iterating over every element and adding individually i get a "tooManyResquests" error, and if I try by chunks it doesn't return an error but simply nothing happens.
Is there a proper way to import a csv file into powerBI using the powershell API, in the same fashion as you would do it manually?
thank you,
Leo
Hi @Anonymous
Are you referrring the regular dataset or push datasets?
The following property is by default disabled for the dataset - "addRowsAPIEnabled": false
If you create a dataset directly using the Powershell then the above property is enabled true so you can use Add-PowerBI.
Check - https://petri.com/how-to-push-data-via-powershell-to-powerbi/
Thanks
Hari
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 |