Forum Discussion

ShawnGu's avatar
ShawnGu
Regular Visitor
2 years ago

Strange Behavior when tracing PowerBI Desktop execution of SSAS Multidimensional cubes

Hi there, we're trying to trace down an issue related to our users getting a transport error while their powerbi datasets are refreshing (PowerBI Service -> PowerBI Gateway -> OnPrem SSAS Multidimen...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Power Query is extremely paranoid about meta data changes and it will issue large quantities of ghost queries (in the style of  SELECT TOP 0 *) to re-fetch meta data over and over again.  That's likely what you are seeing.