cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Juampe Regular Visitor
Regular Visitor

Power BI System Administrator

Hi everyone

I have a question.


I am currently developing using a Power BI Pro account

I need to upload the Dashbaord to the cloud and share it with the client

I am using the account of microsoft that the comnpany give to me ( I am and external COnsultant)


My question is:

Should be an Administrator account to do that? 


I find quite weird that I have to sue my personnala count to publish the dashbaord and share with the organization. any idea?
Another question:
My Data set is so big so the application weight is higher than 1 GB.
I need a Power BI Premium account to publish and reload and share the Dashboard or I can upload the Dashboard with few information and the Reload in the cloud and take the full app with a data set that weights more than 1 GB without usinng Power BI Premium licence?
(I know there is another option --> Direct Query but I cant use it

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Power BI System Administrator

@Juampe For #3, looks like you would get errors in the Service as well -> https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi As another idea you could look to improve the model size, make sure you only have the necessary columns, ensure that the auto date/time in the Options ->Current File->Data Load -> Time Intelligence section is turned off... this will create a date dimension behind the scenes for every date column in every table. It makes reports for small datasets easy to work with but will kill large models and massively increases the model size.

DAX Studio is a great tool to interegate the model, there are a bunch of blogs out there that show how to get table sizes, etc.

If the client does have premium, then I believe you would just need to try publishing to the premium workspace as that should allow up to 3GB (I forget if the cap is still on) PBIX files published.


Near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Power BI System Administrator

@Juampe First, you need to create a workspace that is shared between you and someone from your client. That way, whatever you publish should go to that workspace so you and others have access to the report you built. Second, you could try to set a parameter to minimize the size of the file for upload, then change the parameter in the Service, but you will likely hit the same threshold of 1GB per dataset on a Pro license.

The other alternative is to stick the model in Analysis Services or Azure Analysis Services if that is available to you. Depending on their needs, it could be cheaper than going with a Premium license.


Near SE WI? Join our PUG Milwaukee Brew City PUG
Juampe Regular Visitor
Regular Visitor

Re: Power BI System Administrator

@Seth_C_Bauer  thanks for the response.

1- Yes I know I have to create a workspace to share the Dashbaord

2- First time I hear about create a parametre (I will check it)

3-  if I udnerstood correctly....If I have Pro Licence & my Client too and I upload the dashbaord with small dataset and I refresh the app will be higher than 1GB so... I will still have the problem of 1GB limitation I am right?

4- I will check about Azure... but We are workign with AWS so... I dont know if both are compataible.

5- The company that I am currently working for is one of the highest insurance companies in the wrold so... maybe they have the Premium Licence...

 

Many thanks

Super User
Super User

Re: Power BI System Administrator

@Juampe For #3, looks like you would get errors in the Service as well -> https://docs.microsoft.com/en-us/power-bi/service-admin-manage-your-data-storage-in-power-bi As another idea you could look to improve the model size, make sure you only have the necessary columns, ensure that the auto date/time in the Options ->Current File->Data Load -> Time Intelligence section is turned off... this will create a date dimension behind the scenes for every date column in every table. It makes reports for small datasets easy to work with but will kill large models and massively increases the model size.

DAX Studio is a great tool to interegate the model, there are a bunch of blogs out there that show how to get table sizes, etc.

If the client does have premium, then I believe you would just need to try publishing to the premium workspace as that should allow up to 3GB (I forget if the cap is still on) PBIX files published.


Near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

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,091 guests
Please welcome our newest community members: