Forum Discussion
Helper IData loading blank in Power BI, but appears in Power Query
Hi,
Thanks for the solution Fowmy offered, and i want to offer some more infotmation for user to refer to.
hello RyanHare92 , based on your descriotion, please refresh the data in power query.
After applying the data to desktop, please refresh the data in Desktop by clicking the refresh button.
If it cannot work, you can try to close the desktop and then reopen it, and you can refer to the following similar thread.
Solved: Data showing in Preview on Query Editor but not sh... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super UserRyanHare92
It has happened to me a few times, I clicked on a column header and sorted or filtered which made it work. please try.
Helper IHi Fowmy,
I have tried this, but the values are still blank.
Curiously, if I keep the Name column, that actually shows:
It's as if the values being extracted are not being loaded correctly.
- Fowmy
RyanHare92
Try loading each step starting with Queries = Record.ToTable(#sections[Section1]),- RyanHare92
Data looks as extected until I expand the values. That is when everything loads as blank.
Hi,
Thanks for the solution Fowmy offered, and i want to offer some more infotmation for user to refer to.
hello RyanHare92 , based on your descriotion, please refresh the data in power query.
After applying the data to desktop, please refresh the data in Desktop by clicking the refresh button.
If it cannot work, you can try to close the desktop and then reopen it, and you can refer to the following similar thread.
Solved: Data showing in Preview on Query Editor but not sh... - Microsoft Fabric Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.