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，

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        funcy,

        Do you use merge queries or append queries in Query Editor? I would recommend you make a backup of your current PBIX file, delete the merge queries/append queries steps in Query Editor, and check if refresh works.

        If you still get the error, please remove each source in PBIX file to check when refresh starts to work.

        Regards,
        Lydia