cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Power Query Error - source data changed

Hello,

 

I had an excel file that was a source in a Power BI report I put together.

 

Well the pwbx file was open I opened the excel file to change some data.  Originally the column was a binary (0 or 1) however I updated it to show "Within", "Outside" or "N/A".

 

When I refreshed the data it showed errors going down the column.  I double clicked on the error, and now I'm stuck on the error and don't know how to fix it?  

 

ibesmond_0-1596744540887.png

 

Any advice?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Responsive Resident
Responsive Resident

Re: Power Query Error - source data changed

@ibesmond  as suggested by @Greg_Deckler remove the last step in your query. One of your steps should be "Changed Type1" which is effectively trying to convert your column into "type - number". It must be working fine before as you had 0 and 1 in that column. Now that you have text ("Within" etc), the data "type - number" is not valid which is giving you this error. Remove the "Changed type1" step and hopefully the error should go away

 

Nishant

View solution in original post

2 REPLIES 2
Highlighted
Super User IX
Super User IX

Re: Power Query Error - source data changed

@ibesmond Remove the last step in your query


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Responsive Resident
Responsive Resident

Re: Power Query Error - source data changed

@ibesmond  as suggested by @Greg_Deckler remove the last step in your query. One of your steps should be "Changed Type1" which is effectively trying to convert your column into "type - number". It must be working fine before as you had 0 and 1 in that column. Now that you have text ("Within" etc), the data "type - number" is not valid which is giving you this error. Remove the "Changed type1" step and hopefully the error should go away

 

Nishant

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors