Forum Discussion

anonymous2's avatar
anonymous2
Helper II
4 years ago

Post Import in Power BI REST API

Hi, I would like to try using the Post Import from this documentation, https://docs.microsoft.com/en-us/rest/api/power-bi/imports/post-import to import an excel file or JSON file to Power BI Service ...
Need Help
Show and Tell
Tutorial Requests
lbendlin's avatar
lbendlin
Super User
4 years ago

The authheader contains the bearer token and the Content-type.  My understanding is that "connect" leaves the aexcel file on the SharePoint and creates a reference. Similar to Direct Query. And no, I wasn't successful yet. The only documentation I could find is from 2015 when the API was still in beta.

  • anonymous2's avatar
    anonymous2
    Helper II
    4 years ago

    Hi lbendlin, I used the access token and received this error.

     

    Invoke-RestMethod : Specified value has invalid CRLF characters.
Parameter name: value
At C:\Users\LENOVO\Documents\powerbi.ps1:23 char:1
+ Invoke-RestMethod -Uri "https://api.powerbi.com/v1.0/myorg/groups/816 ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Invoke-RestMethod], ArgumentException
    + FullyQualifiedErrorId : System.ArgumentException,Microsoft.PowerShell.Commands.InvokeRestMethodCommand