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

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

      • funcy's avatar
        funcy
        Frequent Visitor
        8 years ago

        Anonymous

         

        Hello again, sorry for not responding anymore.

         

        coincidentally I managed to make the Report refreshable (Creating a new table for a column that fetches Data from a web-source and merging the two tables afterwards).

        So now, the Dataset doesn't give me the error mentioned before anymore.

         

        The problem now is, that I can't select my Gateway in the Gateway connection Settings of the Dataset.

        It just keeps loading and loading

         

        As you see, the "Use a data gateway" radiobutton is greyed out as my gateway isn't even displayed. Why does it just keep on loading? The gateway is functional as we know, all the sources and credentials are set up and so on.

        I honestly don't want to try a personal gateway before I know that there is now chance of getting this gateway to work.

        The gateway is also Online and connected.

         

        EDIT: I have installed a personal Gateway now. In older versions of my report and all of the reports that i have created to test the data sources / the gateway, I can select the Data gateway (personal mode) and it works flawlessly. But in my actual report, which is the only one that actually needs to be refreshed, it still looks like in the picture above. (I installed the personal gateway on the same machine as the normal on premises one, they're running at the same time)

         

        Thank you,

        funcy