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. 

 

I have one .xlsm (Excel File), one Oracle Database, a Table containing a Calendar of 3 Years, created through M-Functions, and one Jira Instance (multiple APIs to use, each return a JSON File which is processed by Power BI to a table) to get Data from.

Each of the Sources work flawlessly when i create a single report for them. Only in my Actual Report, where all of them are combined, it gives me that Error: "You can't schedule refresh for this dataset because one or more sources currently don't support refresh."

 

Is there any kind of combination method or something, that is not supported by the sheduled refresh? I don't have parameters in the Queries, all of them are hardcoded. 

 

For the Oracle DB Connection I mainly use the Hierarchical Navigation Way, and one Time an actual SQL-Query (select * from Table where ZEIT_START >= trunc(sysdate)-365).

 

Also, the "Include Relationship Columns" function is activated, but works on the Test Reports as well.

I have absolutely no Idea what the unsupported source could be.

 

Thank you.

Need Help

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    funcy Are you using the Personal or (Enterprise) Gateway? Only the personal gateway supports mixing Cloud and On-Premises datasources in the same dataset. The (Enterprise) Gateway does not yet support that combination.

    Is this the issue?

    • funcy's avatar
      funcy
      Frequent Visitor
      8 years ago

      Thanks for your answer. I am using the On-premise Gateway, not the personal one. 

      An old version of the report works very well using this Gateway, the only sources I added are the excel sheet and the Date Table, which is created by Power Bi itself.

       

      Unfortunately I can't try your solution at the moment, but I will as soon as I can on monday.

       

      But there is one Question I have: If it is the Gateways fault, shouldn't there be the error "You don't have any gateway installed or configured for the data sources in this dataset. Please install a new personal gateway or configure the data source for an existing data gateway." ? 

      As this one basically says, that the problem is, that no Gateway is configured for the needed Sources, while the Error I get is "You can't schedule refresh for this dataset because one or more sources currently don't support refresh." which sounds to me more like it's the Reports / Sources fault.

       

      I hope you can follow me.  

  • 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