Difference between revisions of "Power BI Visual"

(Created page with "Enterprise XLCubedWeb users can now embed and link XLCubedWeb reports into PowerBI reports =Pre-requistes * You need the custom visual, please contact support@xlcubed.com wi...")
 
Line 1: Line 1:
 
Enterprise XLCubedWeb users can now embed and link XLCubedWeb reports into PowerBI reports
 
Enterprise XLCubedWeb users can now embed and link XLCubedWeb reports into PowerBI reports
  
=Pre-requistes
+
==Pre-requistes==
  
 
* You need the custom visual, please contact support@xlcubed.com with the full URL of your XLCubedWeb server (as entered by the users)
 
* You need the custom visual, please contact support@xlcubed.com with the full URL of your XLCubedWeb server (as entered by the users)
Line 9: Line 9:
 
* Using PowerBI cloud or PowerBI Report Server (March 2018 or later)
 
* Using PowerBI cloud or PowerBI Report Server (March 2018 or later)
  
=Preparing XLCubedWeb
+
==Preparing XLCubedWeb==
  
 
As PowerBI and XLCubedWeb will be hosted on different servers you need to enable cross-domain access (CORS) on XLCubedWeb, this will allow PowerBI to intergrate correctly with XLCubedWeb.
 
As PowerBI and XLCubedWeb will be hosted on different servers you need to enable cross-domain access (CORS) on XLCubedWeb, this will allow PowerBI to intergrate correctly with XLCubedWeb.
  
==Set Handler order
+
===Set Handler order===
  
==Add customer headers
+
===Add customer headers===
  
=Preparing PowerBI
+
==Preparing PowerBI==
==PowerBI cloud-based
+
===PowerBI cloud-based===
==PowerBI Report server
+
===PowerBI Report server===
  
=Using the custom visual
+
==Using the custom visual==
==Inserting a report
+
===Inserting a report===
==Linking reports via web parameters
+
===Linking reports via web parameters===
  
=Limitations
+
=Limitations=

Revision as of 10:03, 14 May 2018

Enterprise XLCubedWeb users can now embed and link XLCubedWeb reports into PowerBI reports

Pre-requistes

  • You need the custom visual, please contact support@xlcubed.com with the full URL of your XLCubedWeb server (as entered by the users)
  • The XLCubedWeb server must be running as HTTPS
  • You will need to be running V9.1.47 or above
  • You need to be licensed for an Enterprise XLCubedWeb server
  • Using PowerBI cloud or PowerBI Report Server (March 2018 or later)

Preparing XLCubedWeb

As PowerBI and XLCubedWeb will be hosted on different servers you need to enable cross-domain access (CORS) on XLCubedWeb, this will allow PowerBI to intergrate correctly with XLCubedWeb.

Set Handler order

Add customer headers

Preparing PowerBI

PowerBI cloud-based

PowerBI Report server

Using the custom visual

Inserting a report

Linking reports via web parameters

Limitations