Forum Discussion

IntaBruce's avatar
IntaBruce
Icon for Resolver I rankResolver I
4 years ago

Int Overflow

Hi, I am receiving the following error when trying to import tables from SQL Server to Power BI As far as I can tel none of the numeric fields are integer because I have told the query editor to tr...
Need Help
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Can you share your query M code?

IntaBruce's avatar
IntaBruce
Icon for Resolver I rankResolver I
4 years ago

Do you mean this?

 

  • smpa01's avatar
    smpa01
    Icon for Community Champion rankCommunity Champion
    4 years ago

    IntaBruce  do you still get the same error if you delete the following step and load?

     #"Changed Type"

     

    • IntaBruce's avatar
      IntaBruce
      Icon for Resolver I rankResolver I
      4 years ago

      Yes I do

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    Yes. I don't see anything wrong with it though.

     

    If you change all of the types to text in that last step, do you get the same error? If so, I'm guessing it's an issue in the view definition or something similar on the database. Do the views load as expected on the database?