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_")),
    #"Expanded Value" = Table.ExpandTableColumn(FilteredQueries, "Value", {"Owner", "Source", "Query", "Type", "Date modified", "Status"}, {"Owner", "Source", "Query", "Type", "Date modified", "Status"}),
    #"Removed Columns" = Table.RemoveColumns(#"Expanded Value",{"Name"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Removed Columns",{{"Owner", type text}, {"Source", type text}, {"Query", type text}, {"Type", type text}, {"Date modified", type datetime}, {"Status", type text}})
in
    #"Changed Type"

 




As you can see, it is simply appending all the queries that contain _Info_ in the name. In Power Query, this works beautifully and the data shows as expected (I can't share a screenshot as it has confidential information).

However, once I load this into Power BI, it appears like this:


For some reason everything is blank. 

Does anyone know why this is happening?

Many thanks,
Ryan Hare



  • 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.

5 Replies

  • Fowmy's avatar
    Fowmy
    Icon for Super User rankSuper User

    RyanHare92 

    It has happened to me a few times, I clicked on a column header and sorted or filtered which made it work. please try.

    • RyanHare92's avatar
      RyanHare92
      Icon for Helper I rankHelper I

      Hi 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's avatar
        Fowmy
        Icon for Super User rankSuper User

        RyanHare92 

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