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.