Power Query Error

Posts: 6
Joined: Thu Sep 01, 2016 9:09 am

Power Query Error

Postby ammartin » Wed Sep 07, 2016 9:04 am

I'm getting this error in powerpivot that is VERY annoying: The service URL wasn't defined. Try repairing your installation of power query.

Posts: 1
Joined: Thu Mar 09, 2017 12:57 am

Re: Power Query Error

Postby sbuck » Thu Mar 09, 2017 1:19 am

I am also having this problem and there are no good suggestions online. I have Office 2016 so Power Query is built in. I have tried repairing my Office install with no luck. :( I am NOT using Power Pivot, only Power Query. I am using a query from Microsoft Access as a connection in Power Query and then building a normal pivot table and loading to the data model based on the external connection I set up in Power Query (meaning the data is not actually loaded IN Excel). I could just connect straight to my data source and bypass the use of Power Query but I sometimes need to transform the data within Excel. Any ideas anyone? Please help!

Posts: 929
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Power Query Error

Postby MattAllington » Thu Mar 09, 2017 2:39 am

I've never heard of this. Can you post a short video or screen shot of what is happening?
Matt Allington is Self Service BI Consultant, Trainer and Author of the book "Supercharge Power BI".

Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 3 guests