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

[RyanHare92]

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

[Fowmy]

@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]

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]

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

[v-xinruzhu-msft · Accepted solution]

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.