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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Raam28
Frequent Visitor

Embed with report web part in SharePoint Online

1. I want to create tabular kind of reports( No charts) its purely conists tables (rows and cols) is there any restriction or limitation in the number of rows or number of cols we should use in our report for best fit?

 

2. In this criteria i dont want to create dashboards just i want to create reports and i will use 'Embed link for SharePoint (Preview)' option inorder to embed my report inside share point if i created Role level security(RLS) for my users/groups for that report will it work in share point after we embed? how we can do this?

 

 

Hoping for ur suggestions

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @Raam28,

 

Q1:

For limitation of excel table, the maximum number of columns and rows are 65535.

For my opinion, I'd like to use 10 ~ 15 columns.

 

Q2:

You can take a look at below link:

Difference B/w POWER BI PRO and POWER BI Embedded

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

can i have any sample report which has only tabular data?

 

Is there any option we can export those data back to excel for the end user?

 

Please answer

Hi @Raam28,

 

>>Is there any option we can export those data back to excel for the end user?

If you setting the RLS on the dataset, I think it will only export the filtered data, but it has the limitation on rows amount.

 

For detail inforamation about export data to excel, you can refer to below article:

Export data from Power BI visualizations

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.