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

Pragati11's avatar
Pragati11
Super User
4 years ago

HI Anonymous ,

 

It looks like there is something wrong with your Sharepoint connection as you mentioned above that directly loading excel file to Power BI works.

Can you try editing the sharepoint connection details?

 

Thanks,

Pragati

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Where can I do that or what should I try to edit? Could you please advise? Generally I am poining this specific SP site, and in power query editor I am filtering rows as in this SP site I have one more file so after the source step and 1 filter step it looks like:

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

  • 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

  • Pragati11's avatar
    Pragati11
    Super User
    4 years ago

    HI Anonymous ,

     

    So in Power Query Editor, look for SOURCE step:

    Also, do you have many transformation steps in Power Query editor for this dataset? Can you try checking all steps one by one and see if there is anything that has gone wrong? Basically you should be able to identify if there is any step that has caused this issue.

     

    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?