Connecting paginated reports in power bi report builder to sharepoint file

rmoulika — Mon, 14 Jun 2021 18:28:26 GMT

Hi everyone,

I've been trying to look for a way to connect power bi report builder to an xlsx (excel) file i have in sharepoint, but i cant find any documentation supporting this. If someone could help me connect that would be amazing.

Thanks!

Re: Connecting paginated reports in power bi report builder to sharepoint file

v-janeyg-msft — Thu, 17 Jun 2021 03:40:46 GMT

Hi, rmoulika

It seems that there is no direct way to import xlsx file in sharepoint. You can first create a dateset of the xlsx data source in the service, and then connect to the data by connecting to powerbi dataset.

Reference:Power BI Dataset data source support for Paginated Reports is now available | Microsoft Power BI Blog | Microsoft Power BI

If you can download it locally, there is also an odbc connection method.

You can follow the steps: SQLCircuit: SSRS - How to create a report using Excel as a data source

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: Connecting paginated reports in power bi report builder to sharepoint file in Report Server

Connecting paginated reports in power bi report builder to sharepoint file

Re: Connecting paginated reports in power bi report builder to sharepoint file