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: 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".
https://exceleratorbi.com.au/power-bi-online-training/


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 1 guest