Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |