Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Jacob_Barrow
New Member

Power BI Service Refresh Stopped Working (Desktop Still Works)

I know there are several similar posts on here, but none of them seem to address my issue. A few days ago, my Power BI Service stopped successfully refreshing, while my Power BI Desktop still refreshes without a hitch.

The error I get is about corrupted data:

Jacob_Barrow_5-1703856680341.png


The Service will refresh if I only use files up to a certain date, which leads me to believe there is something amiss with my files.

I am importing many files from Azure Blob Storage into my Power BI Desktop, and using the "Combine Files" to combine them into one table.

To try and simplify and debug this, I filter the data down to a single file in the main query and use the same file as the Sample File when doing "Combine Files". I also do this filtering before Expanding.

Jacob_Barrow_19-1703857359536.png


A few steps that I've tried (per other forums):

1) Deleting the Power BI Desktop and reinstalling it (and clearing the Power BI Desktop cache).
2) Creating a new Semantic Model with the above data.
3) Confirming that credentials work in Service and Desktop (using files before 20231214 work)
4) Deleting all columns of data except one, which was a simple index column, to see if I could pare it down to bad data. 
5) Thinking about dates... In the Transform Sample File, I've deleted all columns with dates to rule out issues with null dates.

I think I've narrowed the fault down to the "Expanded Table Column1" step:

Jacob_Barrow_6-1703856850275.png


If I delete that step, everything works. It leads me to think it's something within my Transform File Helper Query, so here is a snapshot of each of the steps within that query:

Sample File:

Source: 

Jacob_Barrow_12-1703857127223.png

Filtered Rows:

Jacob_Barrow_13-1703857153982.png

Filtered Rows1:

Jacob_Barrow_14-1703857170970.png

Navigation1:

Jacob_Barrow_15-1703857186222.png


Transform Sample File:

Source:

Jacob_Barrow_16-1703857215275.png

Navigation:

Jacob_Barrow_17-1703857230862.png

Promoted Headers:

Jacob_Barrow_18-1703857247440.png



A major difference that I'm seeing between the working and non-working files:
- There is an additional column in the non-working files. Not sure why this would matter, though, if I'm using that same file as the Sample File.

 

I don't get any errors on the Desktop side, so I'm wondering if there's some Service magic that's happening here to cause the disagreement. I've been trying to figure this out for over a week, so any help y'all can provide would be tremendously appreciated.

 

 

1 ACCEPTED SOLUTION

Thanks for your quick response! I finally realized that my original data source was creating two columns called "task", which was causing the corruption. Thanks again!

View solution in original post

5 REPLIES 5
Jacob_Barrow
New Member

I've also noticed that there is a column name change between the working and non-working files. I've heard it mentioned before that this can be an issue. But would it be an issue if I filtered down to only files with that matching column name changed before applying the Combine Files?

Hi @Jacob_Barrow 

Did you check the Query folding of each Applied Steps?

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Jacob_Barrow
New Member

**** I should mention that I've successfully done a refresh on the same file by uploading it to the Service through storage in Microsoft Teams. I didn't do Combine Files and just uploaded the single file, and was able to refresh in the Service. Makes me think it's related to using it as a sample file.


Other points, now that I'm thinking about it:
- If I try to use a "non-working file" (i.e., anything 12/14 or after) as the Sample File and filter the data to the "working files" (anything before 12/14) it will fail, however, if I use a 12/13 sample file for data on or before 12/13, it succeeds.
- If I try to use a pre-12/14 Sample File for any files later than 12/14, it will fail because of the added column at 12/14.

What do you mean by Working and not Working File?

In Blob Storage you have Excel files like this 

aj1973_0-1703866633250.png

with dates 20231213***, 20231211*** and you are trying to combine them in Power Query ? is it not?

if so these files, do they have the same structure?

 

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Thanks for your quick response! I finally realized that my original data source was creating two columns called "task", which was causing the corruption. Thanks again!

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors