Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Corvettenut
New Member

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

Hi,

 

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?

3 REPLIES 3
v-jayw-msft
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,

Jay

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.

lbendlin
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

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors