Data Source is empty when I use Blank query with API
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
Power Query Refreshing
Hey everyone! I'm new to the Power BI Community and I'm running into an unexpected issue. I'm using Power BI Report Server and connected to and importing a table from Oracle DB. The problem is, everytime I edit a column or make any tranformation within the data(e.g Replace values), it refreshes the data from the data source, reading the complete database each time and reapplying the filters. As you can imagine, with millions of rows this is causing immense wastage of time and is a serious set back for us. Is this supposed to happen? Or could I be doing something wrong?
