Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have problem when i open TableStorage in PowerBi Desktop.
As you can see on this photo: https://ibb.co/f0o7wm
On the left you can see my Table in Storage Explorer, and on the right EditQueries in PowerBI Desktop.
As you can see a have some missing columns in PowerBi like czas, czas1, czascyklu, czaspl, czaspostoju, czaspracy, nrtaktu, resetcpl.
Why i have situation like that? Do i have to do something to have all the columns in PowerBI?
Thanks in advance 🙂
Solved! Go to Solution.
You got me thinking, and i add those columns in Advenced Edit Query, and now it is all OK.
Thanks 🙂
let Source = AzureStorage.Tables("termettablestorage"), telemetry1 = Source{[Name="telemetry"]}[Data], #"Expanded Content" = Table.ExpandRecordColumn(telemetry1, "Content", {"device", "czas", "czas1", "praca", "pracal", "takt", "time", "ups", "czascyklu", "czaspl", "czaspostoju", "czaspracy", "nrtaktu", "resetcpl"}, {"device", "czas", "czas1", "praca", "pracal", "takt", "time", "ups", "czascyklu", "czaspl", "czaspostoju", "czaspracy", "nrtaktu", "resetcpl"}) in #"Expanded Content"
ot
I can't see the right side of your Power BI query so I can't see what steps have been applied. Can you copy and paste in your query from the Advanced Query Editor?
Hi @Greg_Deckler,
Here is view of whole PowerBI:
I chose in Expanded Content "load more" but i still can't see colums: "czas", "czas1", "czascyklu", "czaspl", "czaspostoju", "czaspracy", "nrtaktu", "resetcpl".
What is different with those columns"? Columns "czas" and "czas1" ware added in Stream Analytisc.
Other ones aren't send in every message.
Here is the Advanced Query Editor code:
let Source = AzureStorage.Tables("tablestoragename"), telemetry1 = Source{[Name="telemetry"]}[Data], #"Expanded Content" = Table.ExpandRecordColumn(telemetry1, "Content", {"device", "praca", "pracal", "takt", "time", "ups"}, {"device", "praca", "pracal", "takt", "time", "ups"}) in #"Expanded Content"
You got me thinking, and i add those columns in Advenced Edit Query, and now it is all OK.
Thanks 🙂
let Source = AzureStorage.Tables("termettablestorage"), telemetry1 = Source{[Name="telemetry"]}[Data], #"Expanded Content" = Table.ExpandRecordColumn(telemetry1, "Content", {"device", "czas", "czas1", "praca", "pracal", "takt", "time", "ups", "czascyklu", "czaspl", "czaspostoju", "czaspracy", "nrtaktu", "resetcpl"}, {"device", "czas", "czas1", "praca", "pracal", "takt", "time", "ups", "czascyklu", "czaspl", "czaspostoju", "czaspracy", "nrtaktu", "resetcpl"}) in #"Expanded Content"
ot