Refresh and NO DATA in my Power BI visuals???

Have you published your Power BI report to the service, refresh the data, and the visuals go blank? Patrick may have an answer for you.

Troubleshooting refresh scenarios

Data types in Power BI Desktop

Damu Venkatesan:


*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.


*******************
LET'S CONNECT!
*******************


***Gear***

#PowerBI #Visuals #GuyInACube

[PallaviChauhan]

You are really lucky for me, Patrick. Everytime I get stuck and get no idea what went wrong. Your video comes up with a clue! Thanks for saving my day!

[donweltzin]

I was excited to see this video, but I was unable to find any filter issues whatsoever. My issue was with only one of my Power BI Reports, the first one I ever created. Turns out, my report was still in 'My workspace'. I republished this in a new Workspace and the refresh now works!!! I didn't know there was this nuance with 'My workspace'.

[intentionallyleftblank]

THANK For 2 days I couldn't understand why my data "disappeared" after the refresh. I cannot believe how simple this was to FIX. THANK YOU!

[charliemather]

I haven't run into this, but good to know. Emphasizes that best practice is to make sure all of the columns are property typed. Since it is also best practice turn off automatic detection of column types, it is even more important to check those manually before exiting Power Query.

[nataschalaros]

Really happy with this video. Encountered the same issue. Had a 0/1 column that after refresh resulted in 0/-1. Report showed no data. Solved now. Thank you for always being so short and clear. Guys in a cube = TOP! You guys even beat ChatGPT :D !

[princessh]

Thanks Patrick! This video came in handy today, ran into the same issue and you came to my rescue!!

[sophiejo]

Okay so this didn't solve my issue BUT still giving you a like and subscribe because this is the first time I watched a "help" video that was EASY to follow and understand. Thank you so much!!!

[Qwerty-fzmr]

Thank you Patrick 🙂. You saved me just before Monday's meeting.

[paubue]

Thank you very much, I had been looking for a solution to my problem for so long, I found it with you!

[yozvbbv]

Thank you! You saved me a few hours of frustration with this clear explanation!

[anujgupta]

Thanks Patrick. you are really amazing ! you saved hours of mine.

[Jarrs]

Thank you so much for this video, encountered this exact scenario and wasn’t able to solve it and was driving me crazy! Did exactly what u said and fixed it straight away! Thank you! ❤

[heli]

Thanks for the video
Please create a video about how to have a custom message when no data in chart

[JenteDeMaertelaere-zbcr]

The fact that i wasted 1 hour of my worktime just to find out it was a filtering issue is just so depressing, thanks for the help!

[testprime]

I run into this 2 weeks ago. Never knew about the issue being documented I just realize this on my own. In the end, always declare what type of data you use, it will save you later down the line.

[adeelyousafMughalsOnline]

That's really helpful. I have same issue and resolved by your suggestion. Thanks for the great help.

[shamf]

Did come across this in using source as SharePoint list, had to do rls based on this column, fixed it using 1 and 0 in rls, got to know while testing. Good to know changing to Boolean solves it easily. Thanks for the tip

[stephhunsley]

This was really helpful! Thanks so much!

[christopher_amarillas_RD]

This worked for me! My problem was that I had a column ("cancel_reason") which contained a "false" text. The format of the column in the PQ was alphanumeric. I proceeded to change to "text" and that fixed my problem.

[matthewshotton]

Bit of an outdated question here... this was my issue in the report, however by changing the type I'm unable to use my switch statement that was looking for "True" or "False" - how can I adjust this to look at the new True/False that is no longer text?