Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
shoaibalvi
Helper I
Helper I

Ideas for publishing the Power BI report

Hi all,

 

I am working on a power BI report that pulls in sales data from Azure data bricks for all markets in my organisation. I intend to publish this report so that users from across the globe can access it at whatever time is convenient to them, use filters for thier respective markets, and perform the analysis.

 

Initially I intended to just "publish" the report so that it goes and sits under apps.powerbi.com and then make the link assessible.

 

However, I am slightly concerned now with the volume of data. The power bi query pulls in tens of thousands of data lines so I am wondering now if there needs to be a different way to publish such reports? E.g. a dedicated server space / domain setup by the IT? If i leave it on app.powerbi.com, it wouldn't be linked to my laptop in anyway I assume, i.e., my laptop doesn't need to be turned on and connected for anyone to view the report?

 

Question 2: I am also wondering if its possible to "pause" the query by default when someone launches the report. I intend to add slicers on the front page for market number and date range, and would prefer if power bi performs query for the selections made on this slicer only. This way the amount of data it needs to retrieve would cut down significantly but I am not sure if its possible?

 

Any ideas / suggestions would be greatly appreciated! thanks!

1 REPLY 1
djurecicK2
Super User
Super User

Hi @shoaibalvi , 

#1) Once published, the report is not connected to your individual laptop. There are data size limitations to the Power BI Pro license, so if you do need more space or better performance, you could consider a Premium Per User license.

https://powerbi.microsoft.com/en-us/pricing/#features-compare-charts

 

If you did go to Premium Per User, then each user that accesses the report will also need the same PPU license.

 

#2) Is your report in import or direct query mode? Especially for Direct Query, you have the right idea to use pre-set filters to prevent all of the data from being loaded. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors