Forum Discussion
Force report to show no data at startup
This doesn't address the issue that behind the scenes Power BI is still pulling all the data into the report, it just hides it. What I am trying to accomplish is similar behavior to SSRS where it retrieves and displays only the data needed based on user's selection of parameters. This means that you don't retrieve anything that is not needed. This is very useful as it saves bandwith/network traffic.
If you are using Import Mode, it will be fast everywhere because the data is local to the file (PBIX). How are you sharing it?
Your circumstance would only apply if you were using Live (Direct Query) mode, where it has to make a call out to the data source and then present the information that it gets back.
Import mode doesn't work that way. If you publish it to the Service or to a Report Server, it's going to render just as fast for everything as far as how long it takes to retrieve the information from the dataset (which is local on the Service/server.
I understand that the data is stored with the actual report on the PBIRS server. It's the actual rendering that takes more time as the company's remote locations connect via Citrix, and bandwith is not very good.