Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago
Solved

Multiple queries replicated to the server when I update a report

Good!

I have a dataset with tables extracted in import mode. When I update the dataset, I see identical queries on the server that are repeated 3 times:

gerardcanals_0-1634817309289.png

The query is:

select "_"." sales_order_number",
"_"." sales_order_item",
"_"." sk_sales_order_material",
"_"." sk_sales_order_customer",
"_"." sk_sales_document_class",
"_"." sk_sales_order_origin",
"_"." sk_sales_order_reason",
"_"." sk_rejection_reason",
"_"." sales_order_item_net_value",
"_"." sales_order_item_unit",
"_"." order_quantity",
"_"." sales_order_item_net_weight",
"_"." sales_order_item_gross_weight",
"_"." sales_order_gross_value",
"_"." sales_order_net_value",
"_"." sales_order_net_value_wo_tax",
"_"." sales_order_total_freights_insurances",
"_"." sales_order_eco_taxes",
"_"." sales_order_additional_discount",
"_"." sales_order_stafo",
"_"." schedule_line_number",
"_"." confirmed_quantity",
"_"." sales_order_item_description",
"_"." sales_order_item_weight_unit",
"_"." sales_agency",
"_"." sales_group",
"_"." sales_order_item_volume_unit",
"_"." sales_order_item_volume",
"_"." sales_order_currency",
"_"." crm_offer",
"_"." sales_order_doc_type",
"_"." sk_sales_order_doc_date",
"_"." sk_fullfilment_date",
"_"." sk_order_header_data_creation",
"_"." sk_order_item_data_creation",
"_"." sk_schedule_line_date",
"_"." sk_order_date",
"_"." sk_order_local_date",
"_"." ind_last_register",
"_"." sk_load",
"_"." sk_delivery_block",
"_"." sk_orders_position_type"
from
(
select fo.*
from sales.ft_orders fo
inner join data.td_parameters pa
on fo.sales_order_stafo = pa.return_value
and pa.value2= 'STAFO'
and pa.value1 = 'VBAP'
) "_"
where "_"." sk_order_date" >= 20181020 and "_"." sales_order_net_value" > -999999999999999

-----------------------------------------------------------------------------------------------------------------

Some time ago something similar happened to me and I found other posts in which it was commented that it was a power BI BUG.

I do not know if this is the same case, nor do I know if a solution to the problem has been found. But this is causing me memory problems and the activity times are getting very long.

Could you help me?

Could it be related to having used power BI parameters to filter the information?

I thought it could be related to the [EnableFolding=true] since, in some of the tables, I use a direct QSL query (with the advanced import options) and Power BI asks me to put [EnableFolding=false] to make it work, but in other cases I have not needed it. But the problem appears in more than one table that doesn't have those conditions.

  • Hello

    I deleted the post because in the end it is a normal process of our server.

    Thank you.

3 Replies

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Icon for Administrator rankAdministrator

      Hello

      I deleted the post because in the end it is a normal process of our server.

      Thank you.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Syndicate_Admin ,

     

    Got it. If so, please Accept your last reply as the solution to make the thread closed. Thanks.😀

     

    Best Regards,

    Eyelyn Qin