Forum Discussion

ChrisD's avatar
ChrisD
New Member
9 years ago

Power BI reporting and SharePoint Online sites

Hi

 

I have a SharePoint Online site collection which has hundreds of sites.

 

What I want to do is publish Power BI reports / dashboards to each of the sites (each report / dashboard will contain data specific to each site).

 

I've done some work in creating dashboards / reports using Power BI desktop and Power BI, set up the gateway etc.

 

Is there a best approach to setting this up in terms of integration? The O365 tenancy isn't on first release so I can't use the Web Part to integrate them into SPO. I don't want to use Power BI embedded as the business model isn't what I'm looking for so is using the REST APIs the only option for integration?

 

How would I identify and direct reporting / dashboard data specific to each site from Power BI to SPO? Can anyone point me to any similar examples / scenarios?

 

Thanks 

 

Chris

Need Help

2 Replies

    • ChrisD's avatar
      ChrisD
      New Member
      9 years ago

      Hi Qiuyun thanks we are using the classic view in SharePoint online and not the modern view which is required for the Web Part.

       

      In relation to viewing the data in SharePoint Online I'm not clear how i should use Power BI to create the reports specific to each site. There are hundreds of sites in SPO. In Power BI there will be datasets that contain data for all of these sites so I need to target the report / dashboard to each site.

       

      Rather than create hundreds of report / dashboards in Power BI is there an alternative way to do this?

       

      Regards

       

      Chris