cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shiva799
Frequent Visitor

Power BI Query

I'm novice in PowerBI and from knowledge I gathered from different sites and forums I find the statement Power BI is better than other reporting technologies. I found in my research that the Direct Query method will allow you to get live data and will not allow any data manipulation but only first million records can be shown. So how is this good when the data you get from sp or tables have records more than a million and you wish that all of it shown?

Second in Import Query you can get all the data from database and also you can manipulate data but only 8 times refresh is possible. Doesn't this mean that the report published in servercan only be viewd by 8 people in a day and rest of the people viewing the report will show only 8th time refreshed data? What about the data in database that are updated after that 8th refresh data? Also there's a 1 GB limit to import query so doesn't this mean its practically defeats the purpose of showing correct reports to viewers?

Am i missing something here? Please explain

Thanks in advance

2 ACCEPTED SOLUTIONS
Anonymous
Not applicable

@Shiva799,

The 1GB limit for import query only applies if you want to publish your report to Power BI Service; otherwise you can have as much data as you want in your Power BI Desktop file. Power BI put a cap on number of times (8 times) you can schedule data refresh automatically per day, but you are free to refresh your data manually as many times you wish. 

View solution in original post

v-yuta-msft
Community Support
Community Support

Hi Shiva799,

 

So your requirement is to achieve larger refresh frequency and no limitation of dataset, right? The premium license can meet your requirement because premium users can have a dedicated hardware wihch is different from shared capacity. In scheduled refreshes, premium user have no limitation like 8x a day when scheduling refreshes with imported models. In addtion, Power BI Premium gives you the advantage of overcommitting your capacity. For example, you can publish more datasets than capacity memory can hold. If the published datasets in your capacity need more memory than can fit in the capacity, some of the datasets will be stored separately in a persistent storage. The persistent storage is part of 100 TBs storage associated with each of your capacities.

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
v-yuta-msft
Community Support
Community Support

Hi Shiva799,

 

So your requirement is to achieve larger refresh frequency and no limitation of dataset, right? The premium license can meet your requirement because premium users can have a dedicated hardware wihch is different from shared capacity. In scheduled refreshes, premium user have no limitation like 8x a day when scheduling refreshes with imported models. In addtion, Power BI Premium gives you the advantage of overcommitting your capacity. For example, you can publish more datasets than capacity memory can hold. If the published datasets in your capacity need more memory than can fit in the capacity, some of the datasets will be stored separately in a persistent storage. The persistent storage is part of 100 TBs storage associated with each of your capacities.

 

Regards,

Jimmy Tao

Anonymous
Not applicable

@Shiva799,

The 1GB limit for import query only applies if you want to publish your report to Power BI Service; otherwise you can have as much data as you want in your Power BI Desktop file. Power BI put a cap on number of times (8 times) you can schedule data refresh automatically per day, but you are free to refresh your data manually as many times you wish. 

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors