Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 ?
Solved! Go to 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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
120 | |
72 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |