Forum Discussion

andrewsimmans's avatar
andrewsimmans
Helper I
9 years ago

Native database queries are run multiple times when refreshing

I am using Native Database Queries as some of the logic needed to extract data is complex and there is already well tested SQL to get the right data.   However, what I am finding is that if I build...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi andrewsimmans,

 

Did you test below steps?

 

1. Get data from datasource. (source table)
2. Create a duplicate query of source table and named it to backup xxx, then cancel the refresh option of current query.

3. Modify the original source data and refresh the source table.

4. Repeat steps 3,4.

 

After above steps, you can see the history data(backup xxx), but I found it seems only works on powr query side. If you apply the change and return to the report view, these table will show the newest data as same as source table.

 

Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous this is not an acceptable solution as we have to modify our several reports just because of a bug of your app.

The real question is : why does a report, including only 1 query, which is associated to 1 table, runs this query multiple times ? And by multiple times I am saying that queries are sometimes run 2 times, sometimes 3 times, etc.

We want you to provide us a real technical solution to this software issue.