Problems Refreshing Dataset After installing September Update

[cheid1977]

After installing the September update I could not refresh any of my tables. I uninstalled the latest (September) version of Power BI and reinstalled the previous version. After reinstalling the previous version I had no problems refreshing any of my datasets.  Has anyone had this problem?

[Roseventura]

Right now all of the files I'm using are TXT files.  The errors I was getting had to do with the Zip Code column which it was importing as numeric and because there are Canadian Zip Codes, it was causing an error.  Nothing I tried worked, which included me changing the column type to Alpha, it would still give me errors in that column.  This was only 1 of several columns where I was receiving errors, but it was enough to stop the refresh.

Rose

[Roseventura]

P.S.  I have since downgraded to the August version and all my problems are gone.

[cheid1977 · Accepted solution]

All my problems go away as well when I downgrade to an earlier version. 

[v-caliao-msft]

Hi @cheid1977,

I downloaded latest version ot Power BI desktopo and tested it on my local environment, we cannot reproduce this issue.

In your scenario, which type of data source are you using? The latest version of Power BI desktop is available on the link below
https://powerbi.microsoft.com/en-us/desktop/

Regards,

Charlie Liao

[cassidy]

@v-caliao-msft  I also can't refresh, but my source is a Dataflow.  Tries to connect for about 30 minutes before I give up and cancel it.  Going to downgrade.

Edit:   @v-caliao-msft  Confirming downgrading to August 2021 allows the refresh, whereas September 2021 does not.

[cheid1977]

I am refreshing and/or loading new .CSV or .txt files using the "import from folder"function.

[DSimma]

Same issue here. 

They changed the Query system and how errors are handled, but never even mentioned it in the release notice. 

Broke every report I have, had to downgrade, after the downgrade everything is fine.

[Roseventura]

Same problem here among other problems. 

Can someone point me to where I can find older versions?  I can only find the latest version.  I'd like to downgrade so I can get things working again.

Rose

[MaBla2]

Same issues here. Refreshing excel datasets isn't properly working anymore with the September update. After installing the August version again it works. It was just one column (one with a % in the header) that seemed to cause problems.

[admin11]

Hi All

For me i encount the same issue , when i try to install Dec 2022 version. ( my org version is June 2022 ).

My issue is i am unable to refresh  , it get credential error.

After i downgrade to June version , it work fine.

Paul