Data Source is empty when I use Blank query with API

Nikhil_D — Fri, 17 Nov 2023 14:47:07 GMT

Hi All,

My API needs to iterate multiple times, so I updated the M code and got the output. However, when I try to refresh the dashboard in Power BI report server, the data source isn't enabled, and when I check the data source settings in Power BI desktop, it's empty. How can I schedule the dashboard?

Below code is used in blank query.

-----------------------------------------------------------------------------------------------------------

let
// Define the function to fetch data from the API
GetData = (url) =>
let
// Make the API request
Source = Json.Document(Web.Contents(url)),
items = Source[items],
hasMore = Source[hasMore],
nextUrl = if hasMore then Source[links]{3}[href] else null,
itemsTable = Table.FromRecords(items)
in
[Items = itemsTable, HasMore = hasMore, NextUrl = nextUrl],

// Define the function to fetch data recursively
FetchDataRecursive = (url, accumulatedData) =>
let
// Fetch the next set of data
nextData = GetData(url),

// Update loop variables
newData = Table.Combine({accumulatedData, nextData[Items]}),
hasNextPage = nextData[HasMore],
nextUrl = nextData[NextUrl]
in
if hasNextPage <> false and nextUrl <> null then
@FetchDataRecursive(nextUrl, newData)
else
newData,

// Initial call to fetch data
apiUrl = "https://au.................................",
initialData = GetData(apiUrl),
finalData = FetchDataRecursive(initialData[NextUrl], initialData[Items])
in
finalData

---------------------------------------------------------------------------------------------------------------------

Datasouce is empty

topic Data Source is empty when I use Blank query with API in Report Server

Data Source is empty when I use Blank query with API