Showing results for 
Search instead for 
Did you mean: 
New Member

How to point a report to use an Excel workbook loaded up on the service



I've uploaded a report. Apart from the Analysis services data source (which is working), the report also needs to connect to a Excel workbook. I've uploaded the workbook to the Workbook bit of the workspace on the powerbi service, but the report data srouce is still giving me a red cross on the gateway as it's still trying to connect to the path to the excel workbook on the disk in my laptop. How do i configure the report to point to the excel workbook i've uploaded?

Community Support
Community Support

Hi @Corvettenut ,


I'm afraid you can't connect workbook in Power BI Service while connecting to Analysis services.


Best Regards,


Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

Thanks for the replies.

Super User
Super User

In Power BI select "Home...Transform Data...Data Source Settings"  and then in Power Query examine and change the Excel connection as needed. Hint: Right click on the Power Query and select "Advanced Editor".

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors
Top Kudoed Authors