Forum Discussion
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:
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
- AnonymousNot applicable
Hi Syndicate_Admin ,
Not very clear. Could you please share the post you mentioned here?
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.
Issues - Microsoft Power BI Community
Best Regards,
Eyelyn Qin- Syndicate_Admin
Administrator
Hello
I deleted the post because in the end it is a normal process of our server.
Thank you.
- AnonymousNot 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