Web.Contents failed to get contents from Salesforce
Hi, Our dataset is failing to refresh with this error. This table does exist in our salesforce production instance. Any help here would be appreciated. Thanks An error occurred while processing the data in the dataset. Refresh failed: Support Dataset has failed to refresh. Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support. Web.Contents failed to get contents from Salesforce' (404): Not Found Table: Support SO. Next refresh for Support Dataset is scheduled for November 8, 2019 13:00 UTC. Learn more > Technical Information Activity Id: 3165d877-5377-4bc5-9bfd-268d9896f29a Request Id: 3c26ff03-5173-49af-8786-0121cebf21b9 Cluster Name: WABI-US-EAST2-redirect.analysis.windows.net Refresh Start Time: November 8, 2019 20:00 UTC Refresh End Time: November 8, 2019 20:01 UTC Something went wrong There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details. Message: Web.Contents failed to get contents from Salesforce (404): Not Found Table: Support SO Item. Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 0243d14f-4fef-43e7-906b-8f0450d8ec22 Request ID: 5d62b8ed-cdfe-20cd-2cf8-a799f1a31f4d Time: 2019-11-12 00:07:35Z
Query contains unsupported function. Function name: Web.Contents for web API
Hi, I have following code I am using to get data from WEB API, I am getting error when I tried to schedule refresh in Powerbi Service. I am not sure what needs to be changed in code to get it work. Error: "You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for dtc_noWorkOrder Data source for dtc_rejected Discover Data Sources Query contains unsupported function. Function name: Web.Contents" M Query: let BaseUrl = "https://forms.logiforms.com/api/1.0/form/371533/data?", InfoUrl = "https://forms.logiforms.com/api/1.0/form/371533/", Token = "YXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX", EntitiesPerPage = 100, GetJson = (Url) => let Options = [Headers=[Authorization = "Basic " & Token ]], RawData = Web.Contents(Url, Options), Json = Json.Document(RawData) in Json, GetEntityCount = () => let Url = InfoUrl, Json = GetJson(Url), Count = Json[data][form][submissions] in Count, GetPage = (Index) => let Skip = "page=" & Text.From(Index), Url = BaseUrl & Skip, Json = GetJson(Url), Value = Json[data][records] in Value, EntityCount = List.Max({ EntitiesPerPage, GetEntityCount() }), PageCount = Number.RoundUp(EntityCount / EntitiesPerPage), PageIndices = { 1 .. PageCount }, Pages = List.Transform(PageIndices, each GetPage(_)), Entities = List.Union(Pages), #"Converted to Table" = Table.FromList(Entities, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"datesubmitted", "Timecard_RecordID", "lfuuid", "User_Name", "User_RecordID", "Rejection_Reason", "User_Functional_Area", "RecordID", "Rejection_Code"}, {"datesubmitted", "Timecard_RecordID", "lfuuid", "User_Name", "User_RecordID", "Rejection_Reason", "User_Functional_Area", "RecordID", "Rejection_Code"}), #"Changed Type" = Table.TransformColumnTypes(#"Expanded Column1",{{"datesubmitted", type datetime}, {"Timecard_RecordID", Int64.Type}, {"lfuuid", type text}, {"User_Name", type text}, {"User_RecordID", Int64.Type}, {"Rejection_Reason", type text}, {"Rejection_Code", type text}, {"RecordID", Int64.Type}, {"User_Functional_Area", type text}}), #"Reordered Columns" = Table.ReorderColumns(#"Changed Type",{"datesubmitted", "lfuuid", "RecordID", "Timecard_RecordID", "User_Name", "User_RecordID", "User_Functional_Area", "Rejection_Reason", "Rejection_Code"}), #"Added Conditional Column" = Table.AddColumn(#"Reordered Columns", "Rejection_Description", each ( if [Rejection_Code] = "Z001" then "Wrong Work Order" else if [Rejection_Code] = "Z002" then "Wrong Segment" else if [Rejection_Code] = "Z003" then "Time Not Approved" else if [Rejection_Code] = "Z004" then "Incorrect Day / Time" else "" )) in #"Added Conditional Column"Web.broswer contents supports anonymous credentials
Hello, I have tried searching for a solution on the other threads but wasnt able to find any. I accidentaly changed the data extension settings to non recommended and when trying to change back Bi still shows the " Web.browser contents supports anonymous credentials" even after refresh and reloading of the app. I am unable to load any data because of this issue. Any suggestions will be helpful Thank you
