hervekoap's avatar
hervekoap
Regular Visitor
4 years ago
Status:
Done

Export-PowerBIDataflow errors: Operation returned an invalid status : code 'Unauthorized'

Hello    I am trying to extract data from my reporting online with powershell   I am doing    Connect-PowerBIServiceAccount   ==> fine receiving acces OK   then I am asking my dataset  Get...
APIS and Embedding
hervekoap's avatar
hervekoap
Regular Visitor
4 years ago

Hy Caiyun 

 

thansk for your help indeed I create a dataflow and it works 

 

but the  Export-PowerBIDataflow  exports the definition of the dataflow where I added only one table

 

I would like to have the data included in the dataflow . 

Is it possible???

 

definition received:

{"name":"test1_luware","description":"","version":"1.0","culture":"en-US","modifiedTime":"2022-02-16T10:30:30.6217584+00:00","pbi:mashup":{"fastCombine":false,"allowNativeQueries":false,"queriesMetadata":{"T":{"queryId":"7599b4e9-a9dc-4eb5-9ee8-1b02d27894f7","queryName":"T","loadEnabled":true}},"document":"section Section1;\r\nshared T = let\r\n Source = Sql.Database(\"sdb_dwh_acc\", \"TEST_LUWARE\"),\r\n Navigation = Source{[Schema = \"dbo\", Item = \"T\"]}[Data]\r\nin\r\n Navigation;\r\n"},"annotations":[{"name":"pbi:QueryGroups","value":"[]"}],"entities":[{"$type":"LocalEntity","name":"T","description":"","pbi:refreshPolicy":{"$type":"FullRefreshPolicy","location":"T.csv"},"attributes":[{"name":"a","dataType":"string"}]}]}T

 

but NO DATA !!!

 

 

 

Completed Ideas