I have an MDX query which pulls data from an SSAS cube and I have started to notice issues where the server says I am in fact running the same query three times concurrently. We first found this problem when we noticed our pulls were taking an extremely long time, and almost crashed the server. Turns out each query was running three times. I have four MDX queries which pull data into the report, then I eventually append these four tables into one fact table in the report. It cannot be an issue with the MDX code, since when I run the code (I always run/refresh one query at a time) in a brand new file, the server says I am only running it once. I have only noticed that the server says I am running the same query three times when I simply refresh or makes changes to the code in a table which then later gets appended. I believe there may be some circular logic in query editor which causes it to run multiple times. Wondering if anyone else has had this issue.
makromer
on:
Fabric Data Pipeline should be able to execute dbt...
on:
Customers should ereceive notifications for all th...
miguel
on:
Recent Data and Recent Connections