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,

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        funcy,

        Do you use the latest version of on-premises gateway?

        Regards,
        Lydia