Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support

    Hi Anonymous ,

    Do you use a gateway?

    Please share me your Error message with text, not screenshot.

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity 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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Translate error: an error occurred while processing data from the dataset

      • Icey's avatar
        Icey
        Icon for Community Support rankCommunity 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