• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Power BI Service May Update: File Size Increase to 1 GB

May 18, 2016   Self-Service BI

We have heard your feedback and we are pleased to announce that you can now upload files to Power BI up to 1 GB in size. We also have several more improvements to our RLS and Analyze in Excel previews and a brand new feature: Favorite Dashboards. Read about these and more below.

Get Data

RLS

Dashboards

Analyze in Excel

File size limit increase to 1 GB

We know many of you are doing analysis that involves large amounts of data and have large data models that you want to put into Power BI to share with others. After hearing your requests and seeing what you want to accomplish, we increased the file size limit for both Excel workbooks and Power BI Desktop files to 1 GB.

When you publish a PBIX file from Desktop, publish an Excel file to Power BI service, or upload an Excel or PBIX file through Get Data in the service, you won’t get a file size limit message unless the file is greater than 1 GB. Additionally, the data will continue to refresh as long as the data model size does not grow beyond 1 GB. After that, refreshing the dataset will give an error message letting you know your dataset is too large, and it will fail to refresh until you filter the data model back down under 1 GB.

Note: This change does not yet work for Excel workbooks uploaded through the Connect flow. The previous data limit still applies. This applies to you if your Excel files open in an Excel Online experience when you open it from your navigation pane. Learn more about the connect flow in our documentation.

Find SSAS servers set up with the Enterprise Gateway and other Gateway updates

The Enterprise Gateway lets you set up SQL Server Analysis Services servers for users inside your company to access. Now when you set up an Enterprise Gateway, users in your company will be able to access these servers in the Power BI service through the Get Data page.

To reach your available SSAS servers, start on the Get Data page and select Databases.

0cf2c23d 4837 4d2c b2dc 12d99fe837ea Power BI Service May Update: File Size Increase to 1 GB

From there, select SQL Server Analysis Services.

f4f3a552 c515 4f42 810c 548c6a609640 Power BI Service May Update: File Size Increase to 1 GB

Here you will be able to see all your SSAS servers and can select the one you want.

We also added support for refreshing datasets that include data from SAP Business Warehouse Server using the gateway and creating UPN mapping rules when you are using Analysis Services with the gateway. You can read more in the Gateways April Update blog.

AAD group support for RLS (preview)

Users can now assign AAD groups (security groups and distribution lists) to a role. This makes it easier to assign roles to a large group of users at once, vastly improving the role assignment process.

Test your RLS roles with reports backed by the dataset with RLS in place (preview)

We’ve heard feedback from users of our RLS preview that you want to test out your rules before sharing out to users, so we adding a feature that lets you test your dataset as a specific role. This will let you make sure the role works as you expect before any users get their hands on your dashboard.

To test out a role, select Test data as role in the contextual menu of a role.

c9e6a3b7 21bc 4c91 88c7 53dd842eb13c Power BI Service May Update: File Size Increase to 1 GB
This displays a view of your report with that particular role applied.

c3afe5af 53cd 4e7d af8b 356ef0f359d4 Power BI Service May Update: File Size Increase to 1 GB

To return to the RLS setup page, in the top navigation select Back to Row-Level Security.

649645e0 e643 47af 805b d3356d6813c8 Power BI Service May Update: File Size Increase to 1 GB

You can also change which role you are viewing as or select a specific user you want to impersonate to test your roles.

3e4962ec e895 4a09 8f29 d4bc0197df0d Power BI Service May Update: File Size Increase to 1 GB

With this, you can have full confidence in the security roles you set up for your data.

Apply RLS to cloud models based on direct queries (preview)

During this preview time for RLS, we are not only adding new features, but also extending what you can apply RLS rules to. You can now create and apply RLS rules for direct query data sources.

Favorite dashboards

We heard from many users that you want to quickly access a few select dashboards that are most important to you. To help you reach the dashboards you go to most, we added a way to favorite those dashboards and make them easily accessible from all your workspaces.

To favorite a dashboard, select Favorite from the top right corner.

3f6cd345 0c87 432a a650 6a3a33bba225 Power BI Service May Update: File Size Increase to 1 GB

When you do this, two things will happen. You will get a notification that it was successful, and the button will update to say Unfavorite. Now, if you click this button, it will remove the dashboard from your favorites list.

d73a715c 6ac6 419a a37a e96166797607 Power BI Service May Update: File Size Increase to 1 GB

You can find all your favorite dashboards by selecting Favorites in the left navigation.

28378ebe 989a 4a4e bf31 8fa7facdaff7 Power BI Service May Update: File Size Increase to 1 GB
On the Favorites page, you will see a list of all your favorite dashboards. From here you can click on a dashboard to open it, use the share icon to share the dashboard, or use the favorite icon to remove the dashboard from your favorites list.

f677be14 ac56 4998 ade7 2b02a4a8a8e7 Power BI Service May Update: File Size Increase to 1 GB

Improved download experience

We want to give you the best experience when downloading updates to the Analyze in Excel feature. With that in mind, we updated the experience for reaching those downloads.

To get the latest update, select the downloads dropdown and choose Analyze in Excel.

370dfed0 701c 4ca0 9452 2413b2cce423 Power BI Service May Update: File Size Increase to 1 GB
From there you will get a dialog that will let you learn more or download the update directly.

778b07e9 3a32 4388 a614 3c8907e68a72 Power BI Service May Update: File Size Increase to 1 GB

Support for RLS

Once you set up RLS, the rules you apply to the data now flow through when a user analyzes the data in Excel. Now when your audience selects Analyze in Excel, they will only see the data they are allowed to access in the Excel file.

Improved error messaging for on-premises Analysis Services databases

Analyze in Excel is not yet available for all data sources and now the experience is much better for data sources we don’t yet support. Previously when you selected Analyze in Excel for an unsupported data source, you wouldn’t get an error message until after you downloaded the ODC file and try to connect to Power BI, and the error message didn’t have much details. Now as soon as you select Analyze in Excel for a data source we don’t support, you’ll see a message letting you know we don’t yet support that data source.

a7511ae2 2a00 4a53 86d0 459c1b75b7ec Power BI Service May Update: File Size Increase to 1 GB

We also released some major updates to Q&A including Q&A support for SQL Server 2016 Analysis Services tabular models. Read more on the dedicated blog for the Q&A updates.

That’s all for this month! We hope that you enjoy this new update and continue sending us valuable feedback about our product. Please don’t forget to vote for other features that you would like to see in the Power BI service in the future.

Let’s block ads! (Why?)

Microsoft Power BI Blog | Microsoft Power BI

File, Increase, Power, service, Size, Update
  • Recent Posts

    • Now make soup!
    • Attach2Dynamics Or SharePoint Security Sync – Choose your smart app for effective document management in Dynamics 365 CRM/Power Apps.
    • 5 jobs that you should apply for this week (before it’s too late)
    • SQL Server authentication methods, logins, and database users
    • DAE solver fails for system of coupled partial differential equations
  • Categories

  • Archives

    • March 2021
    • February 2021
    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited