Power Query Error

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

sbuck
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!

MattAllington
Posts: 898
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 Professional Self Service BI Consultant, Trainer and Author of the book "Learn to Write DAX". You can hire me at http://Exceleratorbi.com.au
http://exceleratorbi.com.au/what-is-power-pivot/
http://xbi.com.au/learndax


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest