data don't load
5 Topics
Full Reports Not Popping Up
So I was trying to pull up data for a company, but the data is only populating three reports. What the IT team has told me is to return back to a postpage? Not sure how that will help, but I just want all reports there for me and not just a limited form of PowerBI. (ITHELP-200904)484Views0likes1CommentMySQL Connection
After gaining access to my newly formatted desktop PC, I downloaded again Power BI, MySQL connector 8.0.16, and an on-premise gateway. Upon connecting to my data hub, I encounter this Failed to update data source credentials: MySQL: Unable to connect to any of the specified MySQL hosts. Activity ID: 3263caea-14ad-48b2-95ea-2fc5657559b0 Request ID: 86eebf39-3655-dddd-8e23-e339c30d8e01 Status code: 400 Time: Thu Sep 29 2022 16:22:08 GMT+0300 (Eastern European Summer Time) Service version: 13.0.19134.41 Client version: 2209.3.13354-train Cluster URI: https://wabi-west-europe-redirect.analysis.windows.net/ May you advise?Solved2.2KViews0likes3CommentsData 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?Solved3KViews0likes2Comments
Distincount wiht slicer
Hi guys, i have a two tables: Entradas (Which has "Año de Ingreso" Column) Desembolsos (Which has "Nro_Operaciones" and "Año Desembolso" column) I need a measure that do Distintcount of "Nro_Operaciones" base on a slicer "Año de Ingreso" I did this measure: Operaciones Desembolsadas por Año = VAR _A= SELECTEDVALUE(Entradas[Año Ingreso]) RETURN CALCULATE(DISTINCTCOUNT(VW_BT_Desembolsos[Nro_Operacion]),FILTER(ALL(VW_BT_Desembolsos),VW_BT_Desembolsos[Año Desembolso]=_A)) It works well if I select only one year in my slicer, but when i have two years selected or none the result is blank. What am i missing?? Thansk!Solved2.2KViews0likes1CommentBrowser Cache Problem
Hi, Recently, some users in my organization reported an error (report does not load data) when accessing the report via browse. The solution was to clear the cache. Someone with the same problem? If so, do you know the cause or the ultimate solution so users don't have to clear the cache? Error reported on 08/06/2021, using google chorme current version. Tks,1.1KViews0likes2Comments
