Forum Discussion
Data not refresh on pbi service
Hello,
I have a problem with my project.
My project resfresh correctly in Power BI desktop but not online.
Please help me.
My code:
let
Source = Json.Document(
Web.Contents("https://XXXXXX.atlassian.net/",
[
RelativePath="rest/api/2/search",
Query=
[
maxResults="100",
jql="project=XXX",
startAt="0"
]
]
)),
numIssues = Source[total],
startAtList = List.Generate(()=>0, each _ < numIssues, each _ +100),
data = List.Transform(startAtList, each Json.Document(Web.Contents("https://XXXXXXX",
[
RelativePath="rest/api/2/search",
Query=
[
maxResults="100",
jql="project=XXX",
startAt=Text.From(_)
]
]))),
iLL = List.Generate(
() => [i=-1, iL={} ],
each [i] < List.Count(data),
each [
i = [i]+1,
iL = data{i}[issues]
],
each [iL]
),
issues = List.Combine(iLL),
#"Converted to Table" = Table.FromList(issues, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Column1 développé" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"fields"}, {"Column1.fields"}),
#"Column1.fields développé" = Table.ExpandRecordColumn(#"Column1 développé", "Column1.fields", {"assignee"}, {"Column1.fields.assignee"}),
#"Column1.fields.assignee développé1" = Table.ExpandRecordColumn(#"Column1.fields développé", "Column1.fields.assignee", {"key", "emailAddress", "avatarUrls", "displayName", "active"}, {"Column1.fields.assignee.key", "Column1.fields.assignee.emailAddress", "Column1.fields.assignee.avatarUrls", "Column1.fields.assignee.displayName", "Column1.fields.assignee.active"}),
#"Colonnes renommées" = Table.RenameColumns(#"Column1.fields.assignee développé1",{{"Column1.fields.assignee.key", "id"}, {"Column1.fields.assignee.emailAddress", "email"}}),
#"Column1.fields.assignee.avatarUrls développé" = Table.ExpandRecordColumn(#"Colonnes renommées", "Column1.fields.assignee.avatarUrls", {"16x16"}, {"Column1.fields.assignee.avatarUrls.16x16"}),
#"Type modifié" = Table.TransformColumnTypes(#"Column1.fields.assignee.avatarUrls développé",{{"email", type text}}),
#"Colonnes renommées1" = Table.RenameColumns(#"Type modifié",{{"Column1.fields.assignee.displayName", "Nom"}}),
#"Type modifié1" = Table.TransformColumnTypes(#"Colonnes renommées1",{{"Nom", type text}}),
#"Colonnes renommées2" = Table.RenameColumns(#"Type modifié1",{{"Column1.fields.assignee.active", "actif"}}),
#"Doublons supprimés" = Table.Distinct(#"Colonnes renommées2"),
#"Lignes vides supprimées" = Table.SelectRows(#"Doublons supprimés", each not List.IsEmpty(List.RemoveMatchingItems(Record.FieldValues(_), {"", null}))),
#"Type modifié2" = Table.TransformColumnTypes(#"Lignes vides supprimées",{{"Column1.fields.assignee.avatarUrls.16x16", type text}}),
#"Colonnes renommées3" = Table.RenameColumns(#"Type modifié2",{{"Column1.fields.assignee.avatarUrls.16x16", "Avatar"}}),
#"Type modifié3" = Table.TransformColumnTypes(#"Colonnes renommées3",{{"id", type text}})
in
#"Type modifié3"
5 Replies
- AnonymousNot applicable
Hello,
I don't use gateway.
The error message:
Web.Contents failed to get contents from 'https://XXXXXXX.atlassian.net/rest/api/2/search?maxResults=100&jql=project%3DCNPR&startAt=0' (400): Table: Dim Composants.
- Icey
Community Support
Hi Anonymous ,
What does this mean?
Please use gateway and try it again.
I don't know much about your issue. Hope this post can help you: Dynamic Web.Contents Power BI Refresh Error.
And if the issue is still there and you are a pro user, not trial, I suggest you to create a support ticket to get further help.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Translate error: an error occurred while processing data from the dataset
- Icey
Community Support
Hi Anonymous ,
If you have create a support ticket, please update your solution here so that people who may have the same question can get the solution directly.
Best Regards,
Icey