I have a Power Bi Report on desktop that when I press refresh it refreshes fine, but I have to do it mannualy every day. I have tried using the web app and the shedule refresh is disabled and I can`t find a workaroun so it refresches daily.
The procees to extraxt the data is to first get the token from a Basic Login (username and paswword) and the output is on json format like this:
{
"Messages": [
{
"Type": "System",
"Level": "Info",
"Message": "Success"
}
],
"Data": {
"SiteId": 1,
"CompanyId": 40,
"TenantCode": "VIV",
"Company": "Vivaaerobus",
"UserId": 10088,
"DisplayName": "vESB Middleware VIV PRD",
"UserName": null,
"Email": "xxx@vesbrim.com",
"Token": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
"TokenScheme": "vToken",
"DateValid": "2025-01-30T14:49:07.3656981+00:00"
From that Json output I need to extract the Token and on this adress create anothe GET API Call:
https://viv.i-soms.com/vesb/api/public/vpos/Report/monthlySalesExt/:DATE
and on the Headers include the Authorization: vToken & (token)
The Date is a parameter and should be YYYY-MM-DD
The output is a CSV Report of the oparatin of that day so I need to do this daily.
This is my power query code that works fine only on desktop side:
Function (Login2) :
() =>
let
body = [username="xxxx@vesbrim.com",password="xxxxxxx"],
Source = Web.Contents("https://viv.i-soms.com/vesb/api/ac/sec/account/login",
[
Headers=[#"Content-Type"="application/json"]
]),
// Convierte el contenido JSON de la respuesta
JsonContent = Json.Document(Source),
// Extrae el token del campo 'Token' dentro de 'Data'
Token = JsonContent[Data][Token]
in
Token
And then another function called (Monthly):
let
let
// Define the start and end dates
DateStart = Date.From(RangeStart),
DateEnd = Date.From(DateTime.FixedLocalNow()),
// Generate a list of dates between the RangeStart and RangeEnd
dateList = List.Dates(DateStart, Duration.Days(DateEnd - DateStart), #duration(1, 0, 0, 0)),
// Function to retrieve data for a single date
GetDataForDate = (Fecha as date) =>
let
searchText = Date.ToText(Fecha, "yyyy-MM-dd"),
url = "https://viv.i-soms.com/vesb/api/public/vpos/Report/monthlySalesExt/",
csvContent = Web.Contents(url, [Headers=[Authorization="vToken " & Login2()],RelativePath = searchText]),
// Convert the CSV content to a table
csvTable = Csv.Document(csvContent, [Delimiter=",", Columns=53, Encoding=1252, QuoteStyle=QuoteStyle.None]),
// Promote the first row to headers
promotedHeaders = Table.PromoteHeaders(csvTable, [PromoteAllScalars=true]),
I works fine only on desktop, I have tried a Destop Custom connector and a web one on power automate but I havent been succesfull on both tries, could any one help me I would appreciate it very much..
