Avatar of Software Engineer
Software Engineer
 asked on

Refreshing Power BI Desktop

When I refresh my report in Power BI Desktop, the data disappears.  How can I eliminate this issue?

Power BI

Avatar of undefined
Last Comment
Software Engineer

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Cédric Tielemans

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Software Engineer

ASKER
Yes, I had checked there.  Advanced Editor is displaying correct references to the environment.  That's why I'm befuddled.
Cédric Tielemans

when in PQ editor you click on the "Source" step, you see the data? If you do go down the steps and see when the data disappears, maybe you have some filter/merge that was added in the query after the last refresh.
Software Engineer

ASKER
I'm sorry, but what is meant by "steps"?  Can you please show a screenshot?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Cédric Tielemans

In PQ editor on the right of the screen you see the Mcode steps visually:
When you click on a step you can see the details in the formula bar in the middle of your screen:

you can make this bar larger by clicking on the little arrow at the right.
Software Engineer

ASKER
Hi There:
Yes, I see data in PQ editor.  I don't see data in the Power BI Desktop itself.
Weird...
SE
Suhas .

1. If the widgets in report itself is not showing: can you please check View->Selection->Show/Hide of widgets to check by any chance widgets are marked as Hide?

or
 
2. I do notice sometime the database table get unselected in data source settings. You may need to re-map the database table.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Cédric Tielemans

That's good news, you don't have a problem in your datasource :). So you see data in in PQ when selecting the last step of your Query right? But when you look at the "Data" view in PBI desktop your table is blank or the data disappears in your "Report" visuals?
Can you verify the query is still loaded, in PQ editor, right click on the Query:

Software Engineer

ASKER
Hi:
I'm unclear.  Below is the list of my five queries in PQ.  The screenshot that you displayed is what I see.
Please let me know if this doesn't answer the question.
Still, why would refreshing prevent the data from displaying in the Power BI Desktop?
SE

Cédric Tielemans

PQ is your first layer of tranformation so if you have a filter here or deactive the load no data will be loaded to your tables. As enable load is set for all your queries you need to check the content of the queries to find the problem. When you select a query you'll see the steps applied on the right of your screen, like this:
These steps are applied top down, starting at your source until the end, if you click on the last step and you see no data you have a filter/merge somewhere that filters out all your data before it's loaded to the PBI desktop table.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Software Engineer

ASKER
I see data, in all steps.
Cédric Tielemans

So you refreshed you dataset, all data disappeared from desktop tables but when you hit "Transform" you see data in all last steps of your queries?
Software Engineer

ASKER
Yes. 
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Cédric Tielemans

So you do have the data in the tables (should have asked this as first question :( )? Just not in the visual? Btw, you only see a field checked when you select a visual.
Software Engineer

ASKER
exactly
Cédric Tielemans

so the problem was that you had no fields added to your visuals? Is it fixed?
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Software Engineer

ASKER
the fields are and were there....
regardless, when I click to "refresh data", all of the data disappears.