Power Automate Search

Search

Re: Split column by data type

Community

Hey 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

Community

Hi @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

Community

When 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

Community

Nice 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

Community

if 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

Community

Please 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

Community

Hi @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

Community

You 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

Community

  if 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)

Community

Thanks! Kicking myself I didn't notice the .. 

Re: How to complete a field to get a fixed length with Power Query / M language

Community

Thanks @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

Community

Thanks 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

Community

crash 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

Community

Hi @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

Community

Hi  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

Community

Hello, 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

Community

Hi @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

Community

Hi @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

Community

Hello   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

Community

Hello!   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

Community

Hi, 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

Community

Thank you both @Rocco_sprmnt21  @Mariusz , your solutions worked well 🙂 Have a good day and thanks!

Re: i,Re: Column transformation

Community

I 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

Community

Here 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 ...