Hello, I want to make a Tree Visual and hence need to prepare my data but I'm having trouble to do so. Data Structure: I have several columns named 'Level 1', 'Level 2', 'Level 3', ...
Hi all, I have a csv file with a huge number of records, when loaded into powe query, I need to add a new custom column that contains the json representation of each record as follows : col1, c...
Hi all, Can anyone please tell me how I can add an index colum but only for certain rows? So for example in the data below I would like rows 4 and 5 to be 1 and 2 respectively.&nb...
Hi, Hoping there's a simple solution to this. I have a CSV with a column containing one or more names separated by spaces. Every name is firstname and lastname but there could be between one...
Hi All, Can hyperlinks to pdf files can be added to Power BI visuals? For example, I have a lot of policies and procedures which is ongoing (writing stage), completed and planned li...
I am new to Power Query and using Power Query to pull data in from an external file. The data has multiple columns. The two columns, Date and Mine, are the ones that I want to use to create a n...
I want to edit/amend an existing dashboard/report and remove non-essential data and am not sure how to do this. I really do not want to create a new report with only the information that is now neede...
...eems that query folding is not supported by the GA4 connector and that therefore incremental refresh of GA4 data in Power BI is pointless. Is this true? Thanks in advance
Hello. I am somehwat familar with the Power Query M Language, but need a little help. I am pulling some data from the Microsoft Graph API. I want to take the data retireved from&nb...