Hi, is it possible to use image from sharepoint in an paginated report in the power bi report server? I have some difficulty to display the image since they need to be authentified
Hi Jeremie! Sorry I'm not sure about this but perhaps these links will help: community.fabric.microsoft.com/t5/Report-Server/SharePoint-Image-to-Paginated-Report/m-p/2476003 community.fabric.microsoft.com/t5/Developer/Sharepoint-Images-not-rendered-in-Paginated-report-RDL/m-p/2094748/highlight/true
@@WiseOwlTutorials Hi, unfortunately, the first link simply said he didn't find any solution and the second use an SQL server which is totally different.
I am finding it difficult to view my report on the PBIRS web portal, I keep getting the following error: An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'Test'. (rsErrorOpeningConnection) A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Try installing SQL server(2012 or higher) and then connecting the Power BI report server to that the database then try again. Hope that solves your issue.
Sir..need VBA help on this.. ColumnA. ColomnB Company. Products Sale ComA. Pro1 ComA. Pro2 ComA. Pro1 ComB. Pro1 Output Extract unique as per criteria Horizontaly expand if we add more Com and Pro.. ComA. ComB Pro1. Pro1 Pro2
You could copy your values in another page, delete duplicates then copy your first column elsewhere, delete duplicates. Put that into arrays, For i = Lbound(Array2, 1) to Ubound(Array2, 1) Cells(1, i) = Array2(i, 1) x = 2 For j = Lbound(Array1, 1) to Ubound(Array1, 1) If Array1(j, 1) = Array2(i, 1) Then Cells(x, i) = Array1(j, 1) x = x + 1 End If Next j Next i Hope this helps. You could also use SQL on a closed workbook. Good luck.
![📊 Power BI [What are Paginated Reports and Should You Use Them?]](http://i.ytimg.com/vi/Dm40UkHmtos/mqdefault.jpg)
Very helpful for me, thanks a lot.
You're welcome Ali, thanks for the comment and for watching!
Many thanks Andrew!
Hi, is it possible to use image from sharepoint in an paginated report in the power bi report server?
I have some difficulty to display the image since they need to be authentified
Hi Jeremie! Sorry I'm not sure about this but perhaps these links will help:
community.fabric.microsoft.com/t5/Report-Server/SharePoint-Image-to-Paginated-Report/m-p/2476003
community.fabric.microsoft.com/t5/Developer/Sharepoint-Images-not-rendered-in-Paginated-report-RDL/m-p/2094748/highlight/true
@@WiseOwlTutorials Hi, unfortunately, the first link simply said he didn't find any solution and the second use an SQL server which is totally different.
Can we make paginated report and power Bi report in pro version of power BI??
paginated report can export to excel, and can Export more than 150k rows right?
thx~!
Yes and yes!
PBIRS print doesn't work on IE. Only option is Paginated Reports.
I really don't get it well why microsoft made two seperate programs as BI report builder and report builder while those two are almost identical?
Agreed, it's confusing!
I am finding it difficult to view my report on the PBIRS web portal, I keep getting the following error:
An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'Test'. (rsErrorOpeningConnection)
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Try installing SQL server(2012 or higher) and then connecting the Power BI report server to that the database then try again. Hope that solves your issue.
Sir..need VBA help on this..
ColumnA. ColomnB
Company. Products Sale
ComA. Pro1
ComA. Pro2
ComA. Pro1
ComB. Pro1
Output
Extract unique as per criteria
Horizontaly expand if we add more Com and Pro..
ComA. ComB
Pro1. Pro1
Pro2
You could copy your values in another page, delete duplicates then copy your first column elsewhere, delete duplicates. Put that into arrays,
For i = Lbound(Array2, 1) to Ubound(Array2, 1)
Cells(1, i) = Array2(i, 1)
x = 2
For j = Lbound(Array1, 1) to Ubound(Array1, 1)
If Array1(j, 1) = Array2(i, 1) Then
Cells(x, i) = Array1(j, 1)
x = x + 1
End If
Next j
Next i
Hope this helps. You could also use SQL on a closed workbook. Good luck.