cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
yusufserki
Regular Visitor

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?

1 ACCEPTED SOLUTION
Icey
Community Support
Community Support

Hi @yusufserki ,

 


 

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? 

refresh report.png

 

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. 

Icey_0-1632712266521.png

 

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.

View solution in original post

2 REPLIES 2
Icey
Community Support
Community Support

Hi @yusufserki ,

 


 

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? 

refresh report.png

 

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. 

Icey_0-1632712266521.png

 

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.

View solution in original post

Thank you so much. It worked like a charm.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!