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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
YunJ
Post Prodigy
Post Prodigy

Why fail to refresh data but success in power query?

Hi,

I want to refresh the dataset, it shows error. When I go to power query, it refresh successfully. After I click close and apply, nothing new refresh... 

1.png2.png

1 ACCEPTED SOLUTION
YunJ
Post Prodigy
Post Prodigy

Change date type in advanced editor can solve it.

1.png

View solution in original post

4 REPLIES 4
YunJ
Post Prodigy
Post Prodigy

Change date type in advanced editor can solve it.

1.png

v-xulin-mstf
Community Support
Community Support

Hi @YunJ,

 

Does your data source on your local?
Please check credentials of data source.

About refresh troubleshooting, please refer:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

 

Best Regards,

Link

amitchandak
Super User
Super User

@YunJ , click on that column showing red. some error should be there in power query

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi,

I don't think that's the problem. There is error because it is null. When I used the previous dataset which loaded successfully, there is also error in the column but nothing influenced.

 

Even if I fix the error, it still cannot refresh.

1.png2.png

Please find the pbix file here:

https://www.dropbox.com/s/om3z8h7qqdfb82q/SBD.pbix?dl=0

 

Thanks for your time.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!