Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data refresh error

HI All, Ive built a power bi report, the data is placed on MS Teams channel in specific folder in a form of xlsx with 2 sheets. Last 2 months there was no problem refreshing it, but today I can s...
Need Help
  • Pragati11's avatar
    Pragati11
    4 years ago

    HI Anonymous ,

     

    The error complains about some data format error.

    Can you try one thing:

    1. Remove Expanded Table step from your applied steps
    2. Again go and click on the icon below to add the expanded step: 

    Thanks,

    Pragati

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hey, so I went through steps and I found something interesting but no idea how to understand it. Like 1st screen is my source "step", 2nd screen is step before the error, and the last screen show error... but I dont remember this one nor I dont understand it, do you have some idea why this specific step failed?

Pragati11's avatar
Pragati11
Super User
4 years ago

HI Anonymous ,

 

The error complains about some data format error.

Can you try one thing:

  1. Remove Expanded Table step from your applied steps
  2. Again go and click on the icon below to add the expanded step: 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you, I had to remove this step and apply it again... and for some reason it worked, although file structure and data types didnt change - very strange.