cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bapt69 Member
Member

Re: Refresh failed only online

What is my authorised memory capacity? (PowerBI Pro pack) I would know how many data I have to "suppress".

 

A screenshot of one data model :

2018-04-20_15h31_32.png

 

 

 

zoloturu
Advisor

Re: Refresh failed only online

@bapt69,

 

There is no fixed capacity per Pro user. That's why it is called SHARED. It depends on how much users are using Power BI Service with shared capacity. 

 

As per my feeling usually, it is around 3-5 GB.

 

  1. Remove not used columns in data load. It means if you want to load Clients table, then prepare view/table on database side with needed fields. (Or while connecting to DB write SQL script where choose required columns).
  2. Reduce the number of rows in a way I told step before (smaller period or any other filters, if possible).
  3. Sometimes better if you will do maximum SQL JOINes on database side then on Power BI side.

 

View solution in original post

bapt69 Member
Member

Re: Refresh failed only online

Ok remove columns sounds good.

I got many many columns useless. If it's an issue, I'll do it.

I let you know.

 

Thank you

bapt69 Member
Member

Re: Refresh failed only online

Ok I remove severals columns and it's working!

 

Thank you,

Highlighted
zoloturu
Advisor

Re: Refresh failed only online

@bapt69,

 

Nice to hear.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 6 members 1,064 guests
Please welcome our newest community members: