Forum Discussion

RyanHare92's avatar
RyanHare92
Icon for Helper I rankHelper I
1 year ago
Solved

Data loading blank in Power BI, but appears in Power Query

Hi, I have the following query:   let Queries = Record.ToTable(#sections[Section1]), FilteredQueries = Table.SelectRows(Queries, each Text.EndsWith([Name], "_Info_")), #"Expande...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.

Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
1 year ago

RyanHare92 

Try loading each step starting with  Queries = Record.ToTable(#sections[Section1]),

RyanHare92's avatar
RyanHare92
Icon for Helper I rankHelper I
1 year ago

Data looks as extected until I expand the values. That is when everything loads as blank.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.