Power Automate Search
Search
Re: Split column by data type
CommunityHey Pat, thanks a lot! It almost worked, the problem is that there are some mixed cells, and when that happens, I don't need the numbers getting pulled to the number column. By adding "0".."9"} ...
Re: Custom connector Oauth Authentication issues
CommunityHi @AfsarP1 , I am not sure which part cause this problem, so I suggest you could open a ticket for this problem(https://powerbi.microsoft.com/en-us/support/) Best Regards, Zoe Z...
Re: Api limit of 1000 records - getting the next 1000 records and so on - Dotdigital, Power BI, Web
CommunityWhen you see their documentation/syntax, you will likely be able to use $skip or $skiptoken in your API call. If so, you can first create a List of numbers that increment by 1000 (API limit), c...
Re: Api limit of 1000 records - getting the next 1000 records and so on - Dotdigital, Power BI, Web
CommunityNice code. The tricky part will be to know when to stop. The documentation says to look at the number of returned rows and stop when it is zero. Maybe a recursive function would be bet...
Re: Join 2 tables with many to many relationship and compare
Communityif you are looking for a result like this: then you have only to merge and expand using UI of power query
Re: Obtain different betwen row above
CommunityPlease see this M code for an example. The example data didn't copy well so there are extra steps in the beginning to clean it up. let Source = Table.FromRows(Json.Doc...
Re: Concatenate Dynamic COlumn
Community@nelsonwhyu I was just giving an hint to to overcome the main problem If you need complete solution, probably is like this: newKey=Table.CombineColumns(Source, level_list, eac...
Re: Merge Queries by text contain
CommunityHi @adrlljh Is this problem sloved? If it is sloved, could you kindly accept it as a solution to close this case and help the other members find it more quickly? If not, please...
Re: Merge Queries by text contain
CommunityYou may need to add more details to your post (see links below) but it seems a Fuzzy Match using a Transformation Table would work. MS defines the transformation table as: Transfo...
Re: Merge Queries by text contain
Communityif I understand your need well, you should take a look at the following link Replace-Values-in-Column-Conditionally-using-Rules-Table
Re: CSV URLs produce Errors in a Table (but not on their own)
CommunityThanks! Kicking myself I didn't notice the ..
Re: How to complete a field to get a fixed length with Power Query / M language
CommunityThanks @Rocco_sprmnt21 I tried your suggestion with Text.PadStart function like this: Text.PadStart([Label1 (txt)],16,"0") and it works fine! Grazie 1000!
Re: Personal gateway can't identified
CommunityThanks for your reply. But I still can't see any gateway in "Manage Gateways". I didn't add any on-prem datasources in my PBIX file. I just inptut the sever name and datasource name in ...
Re: Token EOF Error
Communitycrash and burn. I think I can figure out the year. we will see.. I wanted to get this working first to minimize the number of problems I had at one time!! Thanks for your help!
Re: JSON datetime conversion in power query
CommunityHi @MarkRW2308 , You could try @lbendlin 's suggestions and change it like below let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMj...
Re: Error with Nested IF and Calculate/Filter Condition
CommunityHi v-eachen-msft Thanks for your response. "-" sign is for subtraction. I have to subtract corresponding values for different sources from ABC or ice versa. Have explained the issue a...
Sharing a recently created MS Teams channel link on email
CommunityHello, I built a flow to create an specific set of folders in the Sharepoint behind Teams, then create a Channel in Teams which contains those folders and send an email and a message to myself and o...
Re: How to simplify a column text
CommunityHi @jereaallikko , You can try using EXTRACT feature in query editor as follows: There are multiple options in there. In your case you can try using "Text Between De...
Re: DataFormat.Error after having copied a query from Desktop to Dataflow
CommunityHi @Raph Can you see/find the piece of data that causes the error? Have you checked that you have the right locale set in Dataflow? Is it hte same as in PBI? Please mark the ques...
Re: i,Re: Column transformation
CommunityHello Thanks for your answer. I found a solution today: let Source = AzureCostManagement.Tables("Enrollment Number", "xxxxx", 8, []), usagede...
Duplicate column with offset one row inside grouped table
CommunityHello! Easier to explain in pictures, so: I have grouped the data by user and what I would like to do now is to duplicate the "DateAndTime" column in each user table("Custom" ...
Conditional format
CommunityHi, how do i perform conditional formatting based on the following conditions: billing and hgj/k/l
Re: Duplicate column with offset one row inside grouped table
CommunityThank you both @Rocco_sprmnt21 @Mariusz , your solutions worked well 🙂 Have a good day and thanks!
Re: i,Re: Column transformation
CommunityI know (now) what is your request. what I don't know is which code, of the many received, did you use? where does it give you error? can you show the error screen? hint: try ...
Re: f you are sure Re: A more robust Table.SplitColumn / Splitter.SplitTextByDelimiter
CommunityHere is one way to do it in the query editor. I am assuming you want a list of lists for use in a subsequent step, so you can delete the steps after the ListOfLists step, if so. let ...