Forum Discussion

datatbl123's avatar
datatbl123
Helper I
3 years ago

Import data table from Brightpearl to Power BI

Hi,

 

I am trying to import the sales data from Brightpearl from the "Sales by Product" report into Power BI. I am not sure what the exact query request need to be... I have an app ref as well as token, that's pretty much as far as I was able to go

 

let
Source = Json.Document(Web.Contents("https://not-sure-what-the-url-needs-to-be-here", [Headers=[#"brightpearl-app-ref"="XXX", #"brightpearl-account-token"="XXX="]])),
response = Source[response],
results = response[results],
...
in
...

2 Replies