Multiple Queries to Data Source

[Anonymous]

Hello -

Our organization has heavily adopted PBI over the past six months, which is now putting pressure on our reporting databases.  After digging in with my DBA, we've confirmed that PBI is sending no less than two (sometimes more) of the _exact same_ query to the data source database for every refresh.

In reading a few other posts on the topic, Microsoft has stated this is 'by design', once to refresh the schema, then a 2nd time to load the data.  In the cases when it submits more than 2 copies of the same query, they said this is likely due to the 'data preview' functionality being turned on.

My purpose in posting this to the forum, is to confirm the following and if anyone can add context to Microsoft's design decsion: Do these seem like entirely short-sighted default assumptions for an enterprise reporting platform? 

Some of our data source queries push between 100K - 1M records, and PBI is literally competing with itself by doubling (sometimes tripling) the load on the data tier, thereby increases the likelihood of a data source timeout.

Overall I feel like we're fundamentally misunderstanding Microsoft intended use of this is the default behavior.

Thanks All,

[edhans]

That is how it works. Guy in a Cube did a video on this just in the past two weeks and shows how you can make changes to the Power BI desktop to cut down on the redundancies. But you'd have to go to each desiger's machine and make the changes, and run tests. You can make the wrong changes and increase the number of queries it submits.