blob
3 Topics
Data not updating after publishing blob storage based Power bi reports from Desktop app
Hi, I am facing an issue with my Power bi report after publishing it from Power Bi Desktop. I have a report which sources data in from blob storage, does some computation on it and publishes it to the Power Bi workspace. The report works perfectly fine on Power Bi desktop app, but when I publish it to my workspace, that's when the problem starts. After I publish it, the data on the Web app report does not update even after refreshing it manually using the 'Refresh' button at the top. However, when I go and refresh the data on Power Bi desktop and re-publish, I see the updated data on the Web app. The data on Web app report updates only for a while and then it stops doing that. Here is the Power Query code for the report, I have written: let Source = AzureStorage.Blobs("caiotsandboxstorage"), caiotsandboxhubdata1 = Source{[Name="caiotsandboxhubdata"]}[Data], //Getting files only which are not hidden, has a certain filepath and were modified in last 6 hours #"Filtered Hidden Files1" = Table.SelectRows(caiotsandboxhubdata1, each [Attributes][Hidden] <> true and Text.Contains([Name], "door_sensors/current_sensor") and Number.Abs(Duration.TotalHours(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()) - DateTimeZone.RemoveZone(DateTimeZone.From([Date modified])))) <= 6), #"Binary To Text" = Table.TransformColumns(#"Filtered Hidden Files1", {"Content", Lines.FromBinary}), #"Select Content and Name" = Table.SelectColumns(#"Binary To Text", {"Name", "Content"}), #"Expand Content" = Table.ExpandListColumn(#"Select Content and Name", "Content"), #"Filter Content" = Table.SelectRows(#"Expand Content", each ([Content] <> "")), #"Add Parsed Content" = Table.AddColumn(#"Filter Content", "ParsedContent", each Json.Document([Content])), #"Remove Column Content" = Table.RemoveColumns(#"Add Parsed Content",{"Content"}), #"Expand ParsedContent" = Table.ExpandRecordColumn(#"Remove Column Content", "ParsedContent", {"messages", "id", "sensorLabel"}, {"messages", "id", "sensorLabel"}), #"Expand messages 1" = Table.ExpandListColumn(#"Expand ParsedContent", "messages"), #"Expand messages 2" = Table.ExpandRecordColumn(#"Expand messages 1", "messages", {"current", "timestamp"}, {"current", "timestamp"}), #"Transformed data" = Table.TransformColumnTypes(#"Expand messages 2",{{"timestamp", type datetime}, {"current", type number}}) in #"Transformed data" Could somebody please help me? What am I doing wrong in this?Solved3KViews0likes2CommentsConnect Power BI to Microsoft Azure Blob container
Hi, I am looking to use Ppower BI or Excel Power Query to connect to azure blob with keyvault (our security set up changing keys). the blob connector looks to only have a hardcode key , is there any way around this ? VBA , etc?652Views0likes0Comments
