Forum Discussion

Lund's avatar
Lund
Frequent Visitor
1 year ago
Solved

Can autoupdata my data on Power Bi Web

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 ?

1 Reply