Connecting paginated reports in power bi report builder to sharepoint file

[rmoulika]

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!

[v-janeyg-msft · Accepted solution]

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 Blo...

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.