Forum Discussion

funcy's avatar
funcy
Frequent Visitor
8 years ago

Data Sources don't support refresh when in the same Report

Hello.   This is my first post here and i know, this topic is not a rarity here. My Problem is, that i can't refresh my dataset via PBI web, as one of the Data Sources seem not to be supported.   ...
Need Help
funcy's avatar
funcy
Frequent Visitor
8 years ago

Hello Again, this is the Query / queries for one datasource:

Quelle = Json.Document(Web.Contents("https://jira.company.com/rest/api/2/search?jql=issuetype=Task AND Category=Product AND updated>=-365d&startAt=0&maxResults=500")),
    ...
Quelle19 = Json.Document(Web.Contents("https://jira.company.com/rest/api/2/search?jql=issuetype=Task AND Category=Product AND updated>=-365d&startAt=9500&maxResults=500")),

    
    issues = Quelle[issues] & Quelle1[issues] & Quelle2[issues] & Quelle3[issues] & Quelle4[issues] & Quelle5[issues] & Quelle6[issues] & Quelle7[issues] & Quelle8[issues] & Quelle9[issues] &
             Quelle10[issues] & Quelle11[issues] & Quelle12[issues] & Quelle13[issues] & Quelle14[issues] & Quelle15[issues] & Quelle16[issues] & Quelle17[issues] & Quelle18[issues] & Quelle19[issues]

Don't wonder about those many queries involved, but unfortunately the API can only return 500 Results at once, which isn't really good when expecting a few thousand results. 

I have similar queries for the other APIs:

 

Source = Json.Document(Web.Contents("https://jira.company.com/rest/agile/latest/board/3225/issue?startAt=0&maxResults=500"))
Source = Json.Document(Web.Contents("https://jira.company.com/rest/api/2/project?jql=category=Product&expand=lead"))

The JIRA instance is on premise, as well as the oracle database.

 

Yes I can schedule refresh for each of the sources, when they are in a report alone. I don't use any functions, at least none which wouldn't work with the Gateway as they are all functional in a single report. 

 

Thank you for your help!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

funcy，

What code do you use to create the date table? You are also able to set schedule refresh for the Excel data source, right?

Are you able to use on-premises gateway(personal mode) to refresh your dataset? I found that we are unable to add JIRA data source within on-premises gateway, as there is no such data source.

Regards,
Lydia

  • funcy's avatar
    funcy
    Frequent Visitor
    8 years ago

    This is the code I use for the Date Table:

     

    let
    Start = Date.AddMonths(Date.StartOfMonth(DateTime.LocalNow()),-12),
    End = Date.AddMonths(Start,13),
    Count = Number.From(End-Start)*1,
    Calendar = Table.FromColumns({List.DateTimes(Start,Count,#duration(1,0,0,0))}, type table[Date=date]),

    Yes, I can schedule refresh for all sources, so it also works with excel and the date table. Only not in the Report, where all of them are included together. I connect to JIRA via the source "Web" as it is only an API returning a JSON string.

     

    I don't know if it would work with the personal one as I haven't tried it yet. But I doubt that it works as the error implied that the Report / the sources is the part where it fails already, not the Gateway.

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      funcy,

      Could you please use on-premises gateway(personal mode) and check if you can schedule refresh for the dataset? And would you mind sharing me the PBIX file so that I can test? You can share PBIX file via Private Message.

      Regards,
      Lydia

      • funcy's avatar
        funcy
        Frequent Visitor
        8 years ago

        Hello again,

         

        I have tried to refresh using a personal mode gateway, but it didn't make any difference.

         

        I will send you the template for the report so you can see my steps and data sources, but not the data as it is sensitive business relevant data.

         

        Thank you, regards

        funcy