Forum Discussion

Wouter's avatar
Wouter
Resolver I
10 years ago
Solved

Exclude source from datarefresh

Situation:

 

Made a report with PowerBi Desktop. 3 Sources:

 

- Database 1

- Database 2

- Locale file 

 

There is no need to refresh the locale file content because it is static data.

 

pb.png

 

Is there any way to exclude this.

 

Why:

 

- I'm the author of the report.

- Uploaded it to a GROUP.

- Another member of the group runs the report and should manage the refresh.

- The personal gateway runs on a 'public' dashboard machine with a user (the other member) with minimal access. 

 

Any ideas are greatly appreciated.

  • Have you tried to edit the query properties in PBI Desktop?

     

    - Goto Edit Queries

    - Select the query you want to edit in the left pane

    - select properties

    - uncheck "Enable Refresh of this query"

     

     

3 Replies

  • PowerBIGuy's avatar
    PowerBIGuy
    Responsive Resident

    Have you tried to edit the query properties in PBI Desktop?

     

    - Goto Edit Queries

    - Select the query you want to edit in the left pane

    - select properties

    - uncheck "Enable Refresh of this query"

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hello, Question about this solutions.

      When you publish this report to PBI service i get an error that there is no gateway for refreshing this file.

      Is the exclude refresh only working in PBI desktop?

       

      regards, Bart