User Profile
HadasSpier
Helper I
Joined 5 years ago
User Widgets
Contributions
Unpickle from column with python
Hi everyone, I connected my Power BI report to my SQL DB. I have in my DB a column that contains Pickle files. I need to unpickle that column in Power BI. I tried to do so with python (Run Python Script option): import pickle dataset['value'] = pickle.load(open(dataset['value'], 'rb')) ['value'] is the column that contains the pickles. I got Error: TypeError: expected str, bytes or os.PathLike object, not Series. I didn't find any way to resolve my problem. Thank you!1.7KViews0likes4CommentsRe: Filter page by top 10 occurrences of values in text field
Hi Amit, This example shows TOPN on a number type data field. I need the top 15 values that appear the most times in a text data field, without any connection to another column. I didn't find any example for this situation. Thank you for your time!1.8KViews0likes0CommentsFilter page by top 10 occurrences of values in text field
Hi everyone, I want to filter the page in my Power B.I report by the 15 entries that appear most in a text field. For Example: Category Technology Vendor Hadas something a Livne something b Hadas something a Rotem something a Hadas something c Livne something a Rotem something b Rotem something c Livne something a In this example, if I wanted the top 2 vendors, I want to see only the rows that the vendor value is a or b. Thank you!Solved1.8KViews0likes4CommentsDAX measure with time milliseconds
Hi everyone, I use the following measure: P95_min = VAR T= PERCENTILE.EXC(table[time field],0.95) VAR _H = HOUR(T) VAR _M = MINUTE(T) VAR _S = SECOND(T) return IF( _h <> 0, _H&"h ")& IF( _M <> 0, _M&"m ")& IF( _S <> 0 , _S& "s") In the next column: formated time null 0.00:01:33.000 null null 0.00:02:23.3128517 null null 0.00:02:20.0291237 null 0.00:02:34.3919111 null null 0.00:02:30.6005375 null null 0.00:02:18.3312345 I get an error for this data (for bigger numbers- it works fine). I did not find a built-in function that knows how to work with milliseconds. Would appreciate the help. Thanks in advance!Solved2.2KViews0likes4Comments- 1.6KViews0likes0Comments
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.