Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
Hi @Anonymous ,
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.
Are you using the button on Report page like below?
If so, it will only update the latest data from dataset into visuals on report pages.
To get the latest data from data source (Azure Blog Storage), it is needed to refresh the dataset first and then refresh the report.
Or you can set scheduled refresh like so: Configure scheduled refresh - Power BI | Microsoft Docs.
Reference:
Solved: How to read and extract CSV file in Azure Blob? - Microsoft Power BI Community
Solved: How to refresh automatically data in Report using ... - Microsoft Power BI Community
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
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.
Are you using the button on Report page like below?
If so, it will only update the latest data from dataset into visuals on report pages.
To get the latest data from data source (Azure Blog Storage), it is needed to refresh the dataset first and then refresh the report.
Or you can set scheduled refresh like so: Configure scheduled refresh - Power BI | Microsoft Docs.
Reference:
Solved: How to read and extract CSV file in Azure Blob? - Microsoft Power BI Community
Solved: How to refresh automatically data in Report using ... - Microsoft Power BI Community
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much. It worked like a charm.