User Profile
roelf
Helper II
Joined 9 years ago
User Widgets
Contributions
Re: Failed to open the MSOLAP connection.
Hi - does anyone else have this problem? I am really struggling to find a work around or any interim solution. Is there anyone that knows how to check a ticket status ? I have not received any feedback from MSFT on the issue, which I found strange as surely this is an issue that must render various services unuseable... ?2.6KViews1like0CommentsRe: Failed to open the MSOLAP connection.
Hi Anonymous - can you please provide us an update on this ? I would like to stress again that our services are unavailable at present due to this issue. I will really appreciate if you can give us a time estimate so that I can manage expections this side. Thanks in advance Roelf2.6KViews0likes1CommentRe: Failed to open the MSOLAP connection.
Thanks for the reply. i cannot find a way to check the progress of this ticket, can you please assist? At the moment our services are not operational because of this, so any form of a timeline will be much appreciated so that we can manage expectations this side. Thanks, Roelf2.6KViews0likes0CommentsFailed to open the MSOLAP connection.
Hi We use PBI Embedded, running on an A1 SKU. We have been using RLS for the published reports since 2017 wihtout issues. As of around mid December, we have started seeing the "Failed to open the MSOLAP connection" error when trying to view an embedded RLS Report, for any newly published report. We have changed absolutely nothing in the way we embed or publish, or the user details, etc. If we publish a report, without specifying the Dataset (for RLS purposes), the report opens without any issue - of course without RLS filtering. As soon as we pass the dataset detail, we get the error. Any report that was published before December 2022, on the same infrastructure with the same credentials, settings, etc. does not show this issue. I have read a huge number of posts on this issue, but none of the options have worked. Again - we have changed nothing... but we now get this error. If someone can please assist it will be much appreciated. Thanks Roelf2.7KViews0likes6CommentsRe: Selective sum based on row type
Thanks for the reply mangaus1111 . That partially answers my scenario, but as you can see the "Stack Weights" cumulate, example the second stack weight is 9.85, where it should have been 4.308. So I'm wondering if there is a way to substract a stackweight from a previous one ?612Views0likes0CommentsSelective sum based on row type
***Sorry for the sloppy table format - seems like the forum changes it when I post... Hi I need to be able to sum values in a column, based on a TYPE attribute in the same row. However, I need to be able to "reset" my cumulative total every time a new "set" of values start. My data looks like this: DateTime Type PickWeight 2022/11/04 12:00:00 pick 1.023 2022/11/04 12:00:12 pick 1.002 2022/11/04 12:00:24 pick 1.023 2022/11/04 12:00:36 pick 1.042 2022/11/04 12:00:48 quality 1.023 2022/11/04 12:01:00 pick 1.452 2022/11/04 12:01:12 stack 1.425 2022/11/04 12:01:24 pick 1.236 2022/11/04 12:01:36 quality 1.024 2022/11/04 12:01:48 pick 1.024 2022/11/04 12:02:00 pick 1.023 2022/11/04 12:02:12 pick 1.025 2022/11/04 12:02:24 quality 1.124 2022/11/04 12:02:36 stack 1.023 2022/11/04 12:02:48 pick 1.235 2022/11/04 12:03:00 pick 1.302 2022/11/04 12:03:12 pick 1.223 2022/11/04 12:03:24 stack 1.023 2022/11/04 12:03:36 pick 1.231 2022/11/04 12:03:48 pick 1.023 2022/11/04 12:04:00 pick 1.243 2022/11/04 12:04:12 quality 1.245 2022/11/04 12:04:24 quality 1.245 2022/11/04 12:04:36 stack 1.021 2022/11/04 12:04:48 pick 1.021 I have sorted the data sequentially, and there are various "TYPES" in the dataset. A "set" are all the data entries between two "stack" types. I need to then get the total stack weight, which is the sum of all the "PickWeight" values, between two "stack" types. So the column for "StackWeight" is what i need. DateTime Type PickWeight StackWeight 2022/11/04 12:00:00 pick 1.023 2022/11/04 12:00:12 pick 1.002 2022/11/04 12:00:24 pick 1.023 2022/11/04 12:00:36 pick 1.042 2022/11/04 12:00:48 quality 1.023 2022/11/04 12:01:00 pick 1.452 2022/11/04 12:01:12 stack 1.425 5.542 2022/11/04 12:01:24 pick 1.236 2022/11/04 12:01:36 quality 1.024 2022/11/04 12:01:48 pick 1.024 2022/11/04 12:02:00 pick 1.023 2022/11/04 12:02:12 pick 1.025 2022/11/04 12:02:24 quality 1.124 2022/11/04 12:02:36 stack 1.023 3.072 2022/11/04 12:02:48 pick 1.235 2022/11/04 12:03:00 pick 1.302 2022/11/04 12:03:12 pick 1.223 2022/11/04 12:03:24 stack 1.023 3.76 2022/11/04 12:03:36 pick 1.231 2022/11/04 12:03:48 pick 1.023 2022/11/04 12:04:00 pick 1.243 2022/11/04 12:04:12 quality 1.245 2022/11/04 12:04:24 quality 1.245 2022/11/04 12:04:36 stack 1.021 3.497 2022/11/04 12:04:48 pick 1.021 If there is someone that can assist me it will be greatly appreciated. Thanks ! RoelfSolved661Views0likes3CommentsRe: Cumulative per day per person
Thank you all for your suggestions - they all worked 100% What I ended up using: - Sorted the data in the Power Query - Then added an index - Then used the formula given to get the cumulative amount I have also checked out other examples which suggesting using "RANKX" as a method instead of adding an index column - not sure which is better. I personally preferred adding an index in the query so that I am sure all rows have values. Thanks again all - much appreciated !!1.1KViews1like0CommentsCumulative per day per person
Hi My dashboard is to measure the production of KG's packed, per person, per day in a factory. My data looks like this: Date Person Real Weight 01-Jan-22 Person A 1 01-Jan-22 Person A 1.5 01-Jan-22 Person A 1 01-Jan-22 Person A 1.6 01-Jan-22 Person A 1 01-Jan-22 Person B 3.5 01-Jan-22 Person B 3 01-Jan-22 Person B 1.5 01-Jan-22 Person B 2 02-Jan-22 Person A 1.5 02-Jan-22 Person A 1 02-Jan-22 Person A 1 02-Jan-22 Person A 0.5 02-Jan-22 Person B 1 02-Jan-22 Person B 2 I Need to get it as follows: Date Person Real Weight Cumulative Weight 01-Jan-22 Person A 1 1 01-Jan-22 Person A 1.5 2.5 01-Jan-22 Person A 1 3.5 01-Jan-22 Person A 1.6 5.1 01-Jan-22 Person A 1 6.1 01-Jan-22 Person B 3.5 3.5 01-Jan-22 Person B 3 6.5 01-Jan-22 Person B 1.5 8 01-Jan-22 Person B 2 10 02-Jan-22 Person A 1.5 1.5 02-Jan-22 Person A 1 2.5 02-Jan-22 Person A 1 3.5 02-Jan-22 Person A 0.5 4 02-Jan-22 Person B 1 1 02-Jan-22 Person B 2 3 I then have a futher requirement, where I need to know how much was below and how much over 4 KG. So my table needs to expand to this Date Person Real Weight Cumulative Weight Below 4 Above 4 01-Jan-22 Person A 1 1 1 01-Jan-22 Person A 1.5 2.5 1.5 01-Jan-22 Person A 1 3.5 1 01-Jan-22 Person A 1.6 5.1 0.5 1.1 01-Jan-22 Person A 1 6.1 1 01-Jan-22 Person B 3.5 3.5 3.5 01-Jan-22 Person B 3 6.5 0.5 2.5 01-Jan-22 Person B 1.5 8 1.5 01-Jan-22 Person B 2 10 2 02-Jan-22 Person A 1.5 1.5 1.5 02-Jan-22 Person A 1 2.5 1 02-Jan-22 Person A 1 3.5 1 02-Jan-22 Person A 0.5 4 0.5 02-Jan-22 Person B 1 1 1 02-Jan-22 Person B 2 3 2 I have tried about 5 different ways that I could see on the forum, so thanks to those who's answered a similar problem. I have however not found one that gives me the answer I require. If any of you can assist, it will be much appreciated ! Thanks RoelfSolved1.2KViews0likes4CommentsRe: Dataset Refresh Timeout with SQL server
Hi there I think the problem lies elsewhere though, because in the week of the 18th to 22nd our dataset was refreshing on schedule, within minutes. And while our dataset does increase on a daily basis, there wasn't a rapid increase of data overnight to have led to the dataset timing out after an hour of trying to refresh. What we've also experienced now, is that trying to refresh the dataset locally on the PBI app and publishing, is also causing a time out after +- an hour of publishing (with the error message "You do not have access to publish to this workspace" - which I do). Looking at our report though, it was in fact published/refreshed, but the error message appears to be due to a timeout on the app. As for server resources, we have upped our resources to a higher tier, but it yields the same result: when the dataset is refreshing, our memory usage (according to the graphs) will go up to max, remain constant for a while and then suddenly drop and start to spike rapidly until timing out after an hour or so. I believe it is with this spiking in memory usage that leads to the refresh failing. I guess my question remains: are there common causes for a dataset, that was refreshing normally at a time, to suddenly time out when trying to refresh?1.9KViews0likes1CommentDataset Refresh Timeout with SQL server
Hi there Wondering if someone can help me: We are having an issue with refreshing our dataset that sources data from an SQL server. Looking at our graphs on Azure we can see that as soon as we refresh the dataset on PBI, our memory consuption goes up, remains constant for a while and then starts to spike until it eventually timesout: https://ibb.co/1J9XBp3 If I refresh the data locally on PBI desktop and publish (overwriting the dataset), then it is successful. The problem seems to come in with refreshing on the PBI site. I have a theory that there might be a problem with some of our data (and the query not being able to correctly cast the erroneous data). Would this cause PBI memory to spike, as it tries to run the query? This is a part of our query, where I think the problem may lie: let Source = Sql.Database("name.database.windows.net", [Query="select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source#(lf)UNION ALL#(lf) select * from source", CreateNavigationProperties=false]), #"Removed Columns" = Table.RemoveColumns(Source,{"fruitsize_avg"}), #"Filtered Rows2" = Table.SelectRows(#"Removed Columns", each ([contextref] <> "hs_name")), #"Removed Duplicates" = Table.Distinct(#"Filtered Rows2", {"rid"}), #"Parsed JSON" = Table.TransformColumns(#"Removed Duplicates",{{"totals", Json.Document}}), #"Added item Index" = Table.TransformColumns( #"Parsed JSON", {{"totals", each List.Transform( List.Zip({_, List.Transform( {1..List.Count(_)}, each [Index = _])}), each _{0}&_{1}), type list}}), #"Expanded totals" = Table.ExpandListColumn(#"Added item Index", "totals"), #"Expanded totals1" = Table.ExpandRecordColumn(#"Expanded totals", "totals", {"total", "samples", "value", "Index"}, {"total", "samples", "value", "Index"}) in #"Expanded totals1" Alternatively, are there other possible reasons for why the memory consumption would spike during a dataset refresh - causing it to fail/timeout? Thank you Kind regards1.9KViews0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.