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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

funcy,

Do you connect to On Premises JIRA Instance or JIRA Instance? And do you use function to obtain the JIRA source? We will appreciate that if you can post the code of JIRA data source in Advanced Editor, do mask sensitive information when sharing the code.

Besides, are you able to set schedule refresh for each dataset when you create single reports for each data source? I create a single report that connects to Oracle database via the similar query as yours, when I upload PBIX file to Power BI Service, there is no issue when setting schedule refresh for the dataset as long as I add the Oracle source within gateway.


Regards,
Lydia

  • 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.