Can autoupdata my data on Power Bi Web

[Lund]

Hi

I have build a Power Bi Report with data from Business Central.

Unfornutnalty after publishing, i found out i can't get my report to schedule update and get this error:

You cannot schedule refresh of this semantic model because the following data sources currently do not support refresh:
Data source for Query1

We have 4 companies in business central, and found this way to get Query data from BC the best way.

First i have a FX like this

= (companyName as text) =>
let
    BaseUrl = "https://api.businesscentral.dynamics.com/v2.0/XXXXXXX/XXXXXXX/ODataV4/Company('" & companyName & "')/PBI_Customer",
    Source = OData.Feed(BaseUrl, null, [Implementation="2.0"])
in
    Source

I call that to get my data

let
    Companies = #"Company",
    
    Data = Table.AddColumn(Companies, "", each GetCustomer([Company])),
    #"Udvidet " = Table.ExpandTableColumn(Data, "", {"no", "Bill_to_Customer_No_", "name", "address", "address2", "postCode", "city", "salespersonCode", "customerPriceGroup", "Selek_Budget", "Currency_Code", "E_Mail"}, {"no", "Bill_to_Customer_No_", "name", "address", "address2", "postCode", "city", "salespersonCode", "customerPriceGroup",  "Currency_Code", "E_Mail"}),
    #"Added Custom" = Table.AddColumn(#"Udvidet ", "CustomerLink", each [Company] & "|" & [no] )
in
    #"Added Custom"

I get data and update in Power Bi Desktop like as a charm.

What can i do, so i can autouodata data fra BC in Power Bi Web ?

[MFelix · Accepted solution]

Hi @Lund ,

The problem is that OData is not supported for the schedulle refresh use in a parameter.

Check this post that points out to several links:

https://community.fabric.microsoft.com/t5/Power-Query/Cannot-set-scheduled-refresh-for-odata-with-pa...

https://blog.crossjoin.co.uk/2023/01/15/using-odata-feed-and-the-query-option-to-avoid-the-dynamic-d...