Robuta

https://powerquery.how/ Power Query How - Home of the M Language Dec 30, 2024 - Unlock the Power Query M Language: Explore syntax, data types and language specifics, to help you master data transformation. power queryhome oflanguage https://gorilla.bi/ BI Gorilla: Tutorials for Power Query, DAX and Power BI. Jun 19, 2024 - Learn Power Query, the M Language, and Power BI with our elaborate guides, and take your data analysis skills to the next level with BI Gorilla. for powerbigorillatutorialsquery https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Help/m-p/3969739 Solved: Re: Power Query Help - Microsoft Fabric Community Jun 6, 2024 - Please provide sample data that covers your issue or question completely , in a usable format (not as a screenshot). Do not include sensitive power querymicrosoft fabricsolvedhelpcommunity https://community.fabric.microsoft.com/t5/Desktop/Power-Query-Not-Updating/m-p/1440398 Re: Power Query Not Updating - Microsoft Fabric Community Oct 21, 2020 - yes i have validated excel has updated, but values are not reflected in BI power querymicrosoft fabricupdatingcommunity https://community.fabric.microsoft.com/t5/Desktop/Power-Query-reference-later-added-column/m-p/691863 Solved: Re: Power Query reference later added column - Microsoft Fabric Community May 15, 2019 - Just want to follow up on my previous post, rather than add ton of steps and still can't achieve the goal, at the end I just wrote a short python power querymicrosoft fabricsolvedreference https://community.fabric.microsoft.com/t5/Desktop/Power-Query-grouping-summing-and-nulls/td-p/167243 Solved: Power Query: grouping, summing, and nulls - Microsoft Fabric Community May 1, 2017 - Solved: Let's say I have the following data in a child table: Org Score ABC 32 ABC 29 ABC 33 ABC 30 DEF 38 DEF null DEF null DEF 36 GHI null GHI null power querymicrosoft fabricsolvedgroupingsumming https://learn.microsoft.com/en-us/answers/questions/544653/ssis-power-query-source-error-web-connection SSIS Power Query Source error - web connection - Microsoft Q&A I'm receiving an error when using the Power Query Source within an SSIS data flow. I'm specifically using the web connection, wanting to import data from an... power queryssissourceerrorweb https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Inventory-allocation/m-p/2122075 Solved: Re: Power Query - Inventory allocation - Microsoft Fabric Community Oct 12, 2021 - Hi Ehren Is it still unclear to you? power querymicrosoft fabricsolvedinventoryallocation https://community.fabric.microsoft.com/t5/Issues/Power-Query-in-Semantic-Model-Web-Editor-privacy-settings-don-t/idi-p/5126945 Power Query in Semantic Model Web Editor: privacy ... - Microsoft Fabric Community Mar 6, 2026 - Loading data... (!) Processing queries and validating semantic model. An error has occured. Show details... Underlying Error Privacy settings don't power querysemantic modelweb editormicrosoft fabric https://community.fabric.microsoft.com/t5/Power-Query/Criteria-list-from-existing-Table-in-Power-Query/td-p/3082242 Criteria list from existing Table in Power Query - Microsoft Fabric Community Feb 17, 2023 - I'm not sure I have a name for what I want to do, so I don't know how to search for help. I have a large sheet and in one column there are several power querymicrosoft fabriccriterialistexisting https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-table-transformation/3762599 Power Query table transformation | Microsoft Community Hub Hello Guys! It's nice to meet you all. I straggled with some table transformation in Power Query, and I have no idea how to do it.Do you think if... power querymicrosoft communitytabletransformationhub https://techcommunity.microsoft.com/discussions/excelgeneral/a-question-about-power-query/290495/replies/290534 A Question about Power Query | Microsoft Community Hub The current Excel version I use does not have power query feature. I know it is better than formula to extract data in complex case. However, I would like to... a questionpower querymicrosoft communityhub https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-pop-up-windows-are-transparent-and-clear-Can-t-see/m-p/4795414/highlight/true Re: Power Query pop up windows are transparent and... - Microsoft Fabric Community Sep 4, 2025 - Man, you save my life (and my file). power querypop up https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-API-Authentication/td-p/3115592 Solved: Power Query API Authentication - Microsoft Fabric Community Nov 18, 2024 - Solved: I want to connect to data at https://www.space-track.org/ . It requires an API connection. I can't seem to figure it out in the normal power queryapi authenticationmicrosoft fabricsolvedcommunity https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-load-failure-in-excel-online-/4058804 Power query load failure in Excel online... | Microsoft Community Hub Hi teamIn Excel desktop, I created a power query linking a Excel file in a SP site in another tenant. I can refresh the data in the desktop but get an... power queryexcel onlinemicrosoft communityloadfailure https://www.mimecast.com/de/blog/exploit-using-microsoft-excel-power-query-for-remote-dde-execution-discovered/ Exploit Using Microsoft Excel Power Query for Remote DDE Execution Discovered | Mimecast microsoft excel power query https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services/page/326 Power Query - Page 326 - Microsoft Fabric Community Power Query is the Data Connectivity and Preparation experience across multiple Microsoft products, including Power BI, Excel, Microsoft Dataverse power querymicrosoft fabriccommunity https://skattercabw.web.app/90879/66481.html Power query excel mac power queryexcelmac https://community.fabric.microsoft.com/t5/Desktop/Power-Query-challenge-quot-For-loop-quot-between-two-tables-to/td-p/1533411 Solved: Power Query challenge! "For loop" between two tabl... - Microsoft Fabric Community Dec 8, 2020 - Solved: I need the help of a Power Query expert to create a loop logic as part of a sales data set preparation My input tables are: product synonyms power queryfor loop https://techcommunity.microsoft.com/discussions/excelgeneral/bi-power-query-editor/219695 BI Power Query Editor | Microsoft Community Hub Currently my data looks like this: Description ... power querymicrosoft communitybieditorhub https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/6-new-updates-in-Power-Query-July-2014/ba-p/5174131 6 new updates in Power Query - July 2014 - Microsoft Fabric Community Jul 30, 2014 - In this post Download Power Query Update More flexible Load Options Query Groups Improved Error Debugging Experience Additional Query Editor new updatespower querymicrosoft fabric https://community.fabric.microsoft.com/t5/Desktop/Power-Query-DAX/td-p/4040929 Power Query DAX - Microsoft Fabric Community Jul 14, 2024 - I have a dataset of customers and the services (Plans) they had bought. I am working on a Cross-Selling analysis project. The data is arranged as power querymicrosoft fabricdaxcommunity https://www.jakubkrupa.pl/ Excel, VBA, Power Query, wizualizacja danych - JakubKrupa.pl Nov 3, 2018 - Excel VBA Power Query. Optymalizacja pracy z arkuszami. Automatyzacja raportowania, programowanie VBA, Power Query. Wizualizacja danych. Excel konsultacje. excel vbapower querywizualizacja danychpl https://community.fabric.microsoft.com/t5/Desktop/Power-Query-and-Partial-HTML-Fields/td-p/2968722 Solved: Power Query and Partial HTML Fields - Microsoft Fabric Community Dec 14, 2022 - Solved: I'm running into a strange issue with some of the data I'm importing from a web app. The data is plain text in the web app, but sometimes it power querymicrosoft fabricsolvedpartialhtml https://community.fabric.microsoft.com/t5/Fabric-Ideas/Ability-for-Power-Query-Append-to-Union-tables-without-auto/idc-p/4558466 Ability for Power Query Append to Union tables wit... - Microsoft Fabric Community Feb 24, 2025 - If there are multiple tables that use different refresh frequencies, for performance reasons, you don't want them to auto-refresh whenever you union for power https://tddprojects.atlassian.net/wiki/spaces/SF/pages/58818582/Pulling+Excel+Named+Ranges+into+Power+Query Pulling Excel Named Ranges into Power Query - Salesforce - The Detail Department Confluence power query https://community.fabric.microsoft.com/t5/Desktop/Power-Query-Keep-MaxDateTime-by-Group/m-p/3134166 Solved: Power Query: Keep MaxDateTime by Group - Microsoft Fabric Community Mar 16, 2023 - Solved: Good Afternoon, I have a scenario that I am not able to fully resolve in Power Query I have the following simplified dataset: ReportDate power queryby groupmicrosoft fabricsolvedkeep https://community.fabric.microsoft.com/t5/Desktop/Power-Query-Combining-multiple-Web-BrowserContents-data-sources/td-p/3523811 Solved: Power Query: Combining multiple 'Web.BrowserConten... - Microsoft Fabric Community Dec 14, 2023 - Solved: Hi everyone, I'm looking to create a report that queries multiple different pages of a website. I'm hoping I'll be able to combine them into power querymicrosoft fabricsolvedcombiningmultiple https://community.fabric.microsoft.com/t5/Desktop/Power-Query-reference-later-added-column/m-p/682810/highlight/true Solved: Re: Power Query reference later added column - Microsoft Fabric Community May 15, 2019 - Hi Nick, Thanks for your response, the idea is "Max till Current Row" should be reset to current SOC once there's a deep cycle achieved. In power querymicrosoft fabricsolvedreference https://community.fabric.microsoft.com/t5/Fabric-Ideas/Debugg-in-power-query/idc-p/4547585 Debugg in power query - Microsoft Fabric Community Feb 24, 2025 - It would be helpful to get an option to debug the steps in power query. When I am working with large datasets power query is processing data smoothly power querymicrosoft fabriccommunity https://community.fabric.microsoft.com/t5/Desktop/subtracting-time-from-date-time-power-query/m-p/4633820/highlight/true Solved: Re: subtracting time from date/time power query - Microsoft Fabric Community Apr 1, 2025 - I usually create a custom column with the following: [Your date column] +/- #duration(days, hours, minutes, seconds). To subtract 1 day, 2 hours, 3 power querymicrosoft fabricsolvedsubtractingtime https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services/page/207 Power Query - Page 207 - Microsoft Fabric Community Power Query is the Data Connectivity and Preparation experience across multiple Microsoft products, including Power BI, Excel, Microsoft Dataverse power querymicrosoft fabriccommunity https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-to-merge-tables-into-a-bigger-one/341951 Power Query to merge tables into a bigger one | Microsoft Community Hub Hello, I am trying to create a master table that is fed from other tables (they represent different countries). All the tables have the same headers but... power query https://community.fabric.microsoft.com/t5/Power-Query/Onedrive-Personal-to-Power-Query/m-p/4413827/highlight/true Solved: Re: Onedrive Personal to Power Query - Microsoft Fabric Community Oct 15, 2025 - Use the Web Connector in Power BI Desktop to connect directly to the OneDrive Personal link. the OneDrive for Business connector in Power BI should power querymicrosoft fabricsolvedonedrivepersonal https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/November-Update-of-Power-Query-Preview-is-Now-Available/ba-p/5174375 November Update of Power Query Preview is Now Avai... - Microsoft Fabric Community Nov 11, 2013 - We are very pleased to announce the November Update of Microsoft Power Query Preview for Excel , which you can download from this location . This is november updatepower query https://community.fabric.microsoft.com/t5/Service/Deployment-pipeline-parameter-with-Power-Query/td-p/3299572 Deployment pipeline parameter with Power Query - Microsoft Fabric Community Jun 23, 2023 - Hello, I am trying to set the different data for my Test and Production environment in the same report. What I did was to create the Environment power querymicrosoft fabricdeploymentpipelineparameter https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-source-from-relative-paths/206150/replies/1410052 Power Query Source from Relative Paths | Microsoft Community Hub Hi All, I am making an analysis tool that uses two Excel file sources via Power Query. The tool work well, but as soon as the file and source files... power querymicrosoft communitysourcerelativepaths https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-API-Authentication/m-p/4289736 Solved: Re: Power Query API Authentication - Microsoft Fabric Community Nov 18, 2024 - Hello, the solution proposed worked beautifully until recently. Now login and query must be in two separate steps (spacetrack requirement). I am power queryapi authenticationmicrosoft fabricsolvedcommunity https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Import-mode-with-Filter-merge/m-p/4235490 Solved: Re: Power Query Import mode with Filter/merge - Microsoft Fabric Community Oct 15, 2024 - Don't do it in Power Query? Let the Vertipaq engine do it for you in the data model in memory. power query https://techcommunity.microsoft.com/discussions/excelgeneral/power-query---column-added-in-source/1357923 Power Query - Column added in source | Microsoft Community Hub Hi, I am using Power Query to merge monthly files (extracted monthly from our costumer system) into a single table in Excel. This month... power querymicrosoft communitycolumnaddedsource https://community.fabric.microsoft.com/t5/Desktop/Power-Query-Row-disappear-after-expand-column/m-p/759255 Solved: Re: Power Query - Row disappear after expand colum... - Microsoft Fabric Community Nov 3, 2025 - Thanks for this, unfortunately the Table.Buffer techinque was making my query run incredibly slowly and adding the row count column didn't seem to do power query https://community.fabric.microsoft.com/t5/Fabric-Ideas/Use-Expression-Evaluate-in-Power-Query-with-other-formula-syntax/idi-p/4464956 Use Expression.Evaluate in Power Query with other ... - Microsoft Fabric Community Feb 24, 2025 - What would really be useful is this: to be able to tell Power Query to EVALUATE based on desired source syntax, whether it be Excel, PowerPivot (DAX) power querymicrosoft fabricuseexpressionevaluate https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-source-from-relative-paths/206150/replies/4195161 Power Query Source from Relative Paths | Microsoft Community Hub Hi All, I am making an analysis tool that uses two Excel file sources via Power Query. The tool work well, but as soon as the file and source files... power querymicrosoft communitysourcerelativepaths https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-unable-to-connect-to-mysql/154597 Power Query unable to connect to MySql | Microsoft Community Hub I have installed MySql server on my pc together with MySql connector/ODBC and the Power Query add-in for Excel 2010. I go to "Get External Data from... unable to connectpower querymicrosoft communitymysqlhub https://community.fabric.microsoft.com/t5/Power-BI-Updates-Blog/6-New-Updates-in-Power-Query/ba-p/5174003 6 New Updates in Power Query - Microsoft Fabric Community Jan 13, 2015 - Try what's coming next for Power BI! We hope all of you are enjoying 2015 so far! The Power Query team has been busy working on the latest Power new updatespower querymicrosoft fabriccommunity https://community.fabric.microsoft.com/t5/Fabric-Ideas/visually-indicate-which-power-query-steps-have-comments/idc-p/4512153/highlight/true visually indicate which power query steps have com... - Microsoft Fabric Community Feb 25, 2025 - When we add comments to Power Query steps it isn't obvious that the comments exist. A flag of some sort would be great power querymicrosoft fabricvisuallyindicate https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Help/m-p/3975150 Solved: Re: Power Query Help - Microsoft Fabric Community Jun 6, 2024 - , it's taking a long time to load but would you have any guidance in translating this code to sql so it's not so intensive on Power BI. Uisng power querymicrosoft fabricsolvedhelpcommunity https://community.fabric.microsoft.com/t5/Power-Query/Advice-please-Use-Power-Query-to-replace-remove-the-need-for-RPA/m-p/4008299 Solved: Advice please - Use Power Query to replace/remove ... - Microsoft Fabric Community Jul 9, 2024 - Solved: Hi all, I have a process that uses a mix of Access Database, Power Automate Desktop and Power Automate Cloud. I would like to see if there power query https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-pop-up-windows-are-transparent-and-clear-Can-t-see/m-p/2826404/highlight/true Re: Power Query pop up windows are transparent and... - Microsoft Fabric Community Sep 4, 2025 - Works! Kudos to you, saver! , please mark answer as a solution. power querypop up https://community.fabric.microsoft.com/t5/Desktop/Power-Query-help-to-extract-unique-values/m-p/3125176 Solved: Power Query help to extract unique values - Microsoft Fabric Community Mar 14, 2023 - Solved: So in this case, I am working with a roster list that changes weekly. I have posted a screenshot that shows a small example of what i am power querymicrosoft fabricsolvedhelp https://support.microsoft.com/en-gb/office/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d Merge columns (Power Query) - Microsoft Support With Power Query, you can merge two or more columns in your query. You can merge columns to replace them with a merged column, or create a new merged column... merge columnspower querymicrosoftsupport https://support.microsoft.com/id-id/office/menyimpan-atau-menghapus-baris-duplikat-power-query-d9cffc69-dc5d-4d94-8b66-72779688874d Menyimpan atau menghapus baris duplikat (Power Query) - Dukungan Microsoft Menghapus semua baris dari tabel Power Query, di Editor Kueri, di mana nilai dalam kolom yang dipilih menduplikasi nilai yang lebih lama. power querymenyimpanataubarisduplikat https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-doesnt-load-all-columns/3197991 Power query doesn't load all columns | Microsoft Community Hub Hello, I'm trying to import a TCD from file 1 to file 2 using Power Qwery to automate it but when I laod the data the new table doesn't have all the... power queryload allmicrosoft communitycolumnshub https://community.fabric.microsoft.com/t5/Power-Query/Combining-filtered-column-values-in-Power-Query/m-p/3085421 Solved: Combining filtered column values in Power Query - Microsoft Fabric Community Feb 17, 2023 - Solved: I am not so familiar with M lang, and am straggling to solve the following problem in Power Query: I have the table TABLE1 Date Attribute power querymicrosoft fabricsolvedcombiningfiltered https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-API-with-BodyRequest/m-p/3074646 Solved: Re: Power Query API with BodyRequest - Microsoft Fabric Community Sep 24, 2023 - Yes, I still cannot figure this out! Any suggestions would be greatly appreciated! Thanks! Mikail power querymicrosoft fabricsolvedapicommunity https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Syntax-Error/td-p/1880660 Solved: Power Query Syntax Error - Microsoft Fabric Community Jun 3, 2021 - Solved: Good afternoon, I am using the logic below to create a new table in PBI. let Source = power querysyntax errormicrosoft fabricsolvedcommunity https://community.fabric.microsoft.com/t5/Desktop/subtracting-time-from-date-time-power-query/m-p/685071 Solved: Re: subtracting time from date/time power query - Microsoft Fabric Community Apr 1, 2025 - Thanks for your reply. I think there was a missunderstanding. I have two columns one with Date/Time and another with Time only. Time column is power querymicrosoft fabricsolvedsubtractingtime https://community.fabric.microsoft.com/t5/Power-Query/JSON-Power-Query-experts-Need-help-troubleshooting-dataflow/m-p/2790693/highlight/true Re: JSON / Power Query experts - Need help tro... - Microsoft Fabric Community Sep 28, 2022 - - check the documentation of your API. Your query string looks rather unusual. - put the query in the [Query] section of Web.Contents - examine the power queryneed helpmicrosoft fabricjsonexperts https://support.microsoft.com/pt-pt/office/importar-dados-de-origens-de-dados-power-query-be4330b3-5356-486c-a168-b68e9e616f5a Importar dados de origens de dados (Power Query) - Suporte da Microsoft Utilize Power Query no Excel para importar dados para o Excel a partir de uma grande variedade de origens de dados populares, incluindo CSV, XML, JSON, PDF,... power queryimportardadosdeorigens https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services/page/723 Power Query - Page 723 - Microsoft Fabric Community Power Query is the Data Connectivity and Preparation experience across multiple Microsoft products, including Power BI, Excel, Microsoft Dataverse power querymicrosoft fabriccommunity https://community.fabric.microsoft.com/t5/Fabric-Ideas/Support-many-date-formats-in-Power-Query-Date-Parse/idi-p/4494352 Support many date formats in Power Query Date Pars... - Microsoft Fabric Community Feb 24, 2025 - The Date Parse feature in Power Query is very limited. It doesn't support many common date formats, like "Apr 84" or date formatspower querymicrosoft fabricsupportmany https://community.fabric.microsoft.com/t5/Desktop/Merge-in-Power-Query-based-on-conditions/td-p/319141 Solved: Merge in Power Query based on conditions - Microsoft Fabric Community Dec 8, 2017 - Solved: How to merge the same table based on two conditions in PowerQuery? For example in SQL: select * from Table1 t1 inner join Table1 t2 on power querybased onmicrosoft fabricsolvedmerge https://community.fabric.microsoft.com/t5/Desktop/Error-while-doing-PIVOT-in-power-query/m-p/4763905/highlight/true Solved: Error while doing PIVOT in power query - Microsoft Fabric Community Jul 31, 2025 - Solved: Hi, I have table like below generated from PDF file, when i tried to pivot based on Field name and Value with Don't Aggregate, there is an power querymicrosoft fabricsolvederrorpivot https://community.fabric.microsoft.com/t5/Desktop/Power-Query-M-version-of-CALENDARAUTO-DAX-function/m-p/130364 Re: Power Query /M version of CALENDARAUTO() DAX f... - Microsoft Fabric Community Feb 20, 2017 - Igor, I was trying to tackle a similar problem the other day. I created a function to find the MIN date which I call when creating the date table. I power query m https://community.fabric.microsoft.com/t5/Fabric-Ideas/Power-Query-Feature-addition-To-keep-duplicates/idi-p/4706286 Power Query - Feature addition - To keep duplicat... - Microsoft Fabric Community Jun 23, 2025 - It would be useful to have an M function to keep duplicates based on selected column(s). This would allow the users to see the user to recognise power querymicrosoft fabricfeatureadditionkeep https://community.fabric.microsoft.com/t5/Translated-Spanish-Desktop/Columna-personalizada-en-Power-Query-para-comprobar-agrupaciones/m-p/2932041 Solved: Columna personalizada en Power Query para comproba... - Microsoft Fabric Community Nov 30, 2022 - Solved: Hola equipo, espero que alguien pueda ayudar. Tengo una tabla que muestra varios archivos (columna "URL"), algunos con etiquetas power querymicrosoft fabricsolvedcolumnapersonalizada https://community.fabric.microsoft.com/t5/Power-Query/Divide-formula-in-power-query/m-p/3866705/highlight/true Solved: Re: Divide formula in power query - Microsoft Fabric Community Apr 24, 2024 - Hi , The Error: Divide by zero error encountered means the divisor you are using, i.e. column msdyn_plannedsales, has a value of 0 or a null value. power querymicrosoft fabricsolveddivideformula https://community.fabric.microsoft.com/t5/Power-Query/Filter-Data-in-Power-Query-Dynamically/m-p/3039057 Solved: Filter Data in Power Query Dynamically - Microsoft Fabric Community Jan 25, 2023 - Solved: Hello Team - I have a dataset in my Power BI report that uses CSV file as source. One of the column is Quarter and the other column is filter datapower querymicrosoft fabricsolvedcommunity https://community.fabric.microsoft.com/t5/Desktop/Moving-Calculated-field-to-Power-Query/m-p/2916072 Solved: Re: Moving Calculated field to Power Query - Microsoft Fabric Community Nov 18, 2022 - No. Try to add the conditional column in PQ instead. It is even better. power querymicrosoft fabricsolvedmovingcalculated https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services/page/806 Power Query - Page 806 - Microsoft Fabric Community Power Query is the Data Connectivity and Preparation experience across multiple Microsoft products, including Power BI, Excel, Microsoft Dataverse power querymicrosoft fabriccommunity https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Inventory-allocation/m-p/2118720 Solved: Re: Power Query - Inventory allocation - Microsoft Fabric Community Oct 12, 2021 - Hi @Djpejsen , So the table below is the one you wanna get? If so,dax would be much easier,will you consider about using dax to realize it? Best power querymicrosoft fabricsolvedinventoryallocation https://learn.microsoft.com/nl-nl/power-query/ documentatie voor Power Query - Power Query | Microsoft Learn Power Query wordt gebruikt voor het filteren, combineren en samenvoegen van gegevens uit een of meer ondersteunde gegevensbronnen. power querydocumentatievoormicrosoftlearn https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-lost-decimal-values-in-numbers/m-p/2855490/highlight/true Solved: Power Query lost decimal values in numbers - Microsoft Fabric Community Oct 22, 2022 - Solved: Hi all, I have a dataset from Excel file that has number columns mostly containing decimal values up to 2 digits. Many values are 0.01, 0.02, power queryin numbersmicrosoft fabricsolvedlost https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-API-Authentication/m-p/3118032 Solved: Re: Power Query API Authentication - Microsoft Fabric Community Nov 18, 2024 - Hi Based on the: Optional Method: You can use a single command to both log in and query the database by including the query in the POST request of power queryapi authenticationmicrosoft fabricsolvedcommunity https://community.fabric.microsoft.com/t5/Desktop/Extract-text-Power-query-issue/m-p/367454 Solved: Re: Extract text, Power query issue - Microsoft Fabric Community Feb 28, 2018 - , Add a blank query in your PBIX file, then paste the following code to Advanced Editor of the blank query. let Source = extract textpower querymicrosoft fabricsolvedissue https://community.fabric.microsoft.com/t5/Desktop/Power-Query-calculate-percentage-for-specific-year/m-p/3494283 Solved: Re: Power Query calculate percentage for specific ... - Microsoft Fabric Community Oct 25, 2023 - Try something like this: %OfRequestsAdjusted = VAR SelectedYear = SELECTEDVALUE('output-tickets'[YearColumn]) VAR TicketsInSelectedYear = CALCULATE( power querymicrosoft fabricsolvedcalculate https://techcommunity.microsoft.com/discussions/sharepoint_general/excel-power-query-on-sharepoint-online---update-not-working/1584111/replies/2301292 Excel Power Query on SharePoint Online - update not working | Microsoft Community Hub Excel Power queries have been created to collect and merge customer data. Due to size issues, the data is consolidated in two different files (one for 2020... excel power querysharepoint online https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-relative-path-for-onedrive-and-other-users/2563760/replies/2563918 Power Query Relative Path for OneDrive and Other Users | Microsoft Community Hub Let me start by saying that I have read the posts about converting from an Absolute path to a Relative path in PowerQuery... power queryrelative path https://learn.microsoft.com/en-us/power-query/connectors/text-csv Power Query Text/CSV connector - Power Query | Microsoft Learn Provides basic information and connection instructions, along with troubleshooting tips when loading files from the web and when unstructured text is... power querycsv connectortextmicrosoftlearn https://community.fabric.microsoft.com/t5/Power-Query/Power-query-Blanks-values/m-p/1151705 Solved: Power query Blanks values - Microsoft Fabric Community Jun 11, 2020 - Solved: Hi, I need to remove the blank option that comes from the list. Not sure why is showing blank as the list doesn't have blank values: power querymicrosoft fabricsolvedblanksvalues https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Performance/m-p/2277521 Re: Power Query Performance - Microsoft Fabric Community Jan 14, 2022 - Understood but I have to cherry pick what I spend my time on. A lot of those articles are too deep and others I already know about. There are some power querymicrosoft fabricperformancecommunity https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-fails-on-loading-large-sharepoint-list/88804 Power Query fails on loading large SharePoint List | Microsoft Community Hub power querysharepoint listmicrosoft communityfailsloading https://community.fabric.microsoft.com/t5/Power-Query/Recursive-hierarchy-in-power-query/td-p/4781484 Solved: Recursive hierarchy in power query - Microsoft Fabric Community Jul 31, 2025 - Solved: Hello, my data is: I hve simple table like here: EmployeeID Name ManagerID 1 Alice NULL 2 Bob 1 3 Carol 1 4 Dave 2 5 Eve 2 6 Frank 3 and need power querymicrosoft fabricsolvedrecursivehierarchy https://community.fabric.microsoft.com/t5/Power-Query/transforming-excel-sheet-in-power-query-editor/m-p/3993826 Re: transforming excel sheet in power query editor - Microsoft Fabric Community Jun 18, 2024 - I thought you wrote your problem was that you had more columns. This screenshot still only shows three columns. I don't see how it is helpful for excel sheetpower querymicrosoft fabrictransforming https://community.fabric.microsoft.com/t5/Power-Query/bd-p/power-bi-services/page/145 Power Query - Page 145 - Microsoft Fabric Community Power Query is the Data Connectivity and Preparation experience across multiple Microsoft products, including Power BI, Excel, Microsoft Dataverse power querymicrosoft fabriccommunity https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Anomaly-Transformations-truncate-my-dataset/td-p/4019408 Solved: Power Query - Anomaly - Transformations truncate m... - Microsoft Fabric Community Jul 4, 2024 - Solved: Hello Community! I am currently facing anomalous behavior when trying to perform transformations in Power Query. I attach a description of power querymicrosoft fabricsolvedanomalytransformations https://support.microsoft.com/en-au/office/import-data-from-data-sources-power-query-be4330b3-5356-486c-a168-b68e9e616f5a Import data from data sources (Power Query) - Microsoft Support Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more. import datapower querysourcesmicrosoftsupport https://techcommunity.microsoft.com/discussions/excelgeneral/power-query-source-from-relative-paths/206150/replies/3732228 Power Query Source from Relative Paths | Microsoft Community Hub Hi All, I am making an analysis tool that uses two Excel file sources via Power Query. The tool work well, but as soon as the file and source files... power querymicrosoft communitysourcerelativepaths https://techcommunity.microsoft.com/discussions/excelgeneral/excel-for-mac-power-query-conditional-column-with-percentages/3928682 Excel for Mac Power Query Conditional Column with Percentages | Microsoft Community Hub I'm trying to add a conditional column in power query on a value that that is a percentage, but I cannot figure out what value it will accept as a valid... for macpower query https://community.fabric.microsoft.com/t5/Power-Query/Replicar-Consultas-power-Query/m-p/3997084 Solved: Re: Replicar Consultas power Query - Microsoft Fabric Community Jun 17, 2024 - Hi , Yes. You might consider creating custom functions. A function consists of a query that performs the desired transformation and then converts it power querymicrosoft fabricsolvedconsultascommunity https://techcommunity.microsoft.com/discussions/sharepoint_general/shared-sharepoint--power-query-incompatible/4513773 Shared SharePoint & Power Query incompatible? | Microsoft Community Hub Hello, I am currently working on a file in a Shared SharePoint from an external company. I am only able to open the file in the browser and when I try... power querymicrosoft communitysharedsharepointincompatible https://community.fabric.microsoft.com/t5/Fabric-Ideas/Progress-Bar-for-Power-Query/idi-p/4881210 Progress Bar for Power Query - Microsoft Fabric Community Nov 20, 2025 - Can you develop a way of tracking the progress of a reload/refresh in Power Query, when updating queries and reloading the app. progress barfor powermicrosoft fabricquerycommunity https://community.fabric.microsoft.com/t5/Power-Query/Track-Changes-or-prevent-changes-to-Power-Query/td-p/4155038 Track Changes (or prevent changes) to Power Query - Microsoft Fabric Community Sep 17, 2024 - I have a PBI model that I need to prove to auditors has not been modified. Is there some way to see or track changes made within Power Query? track changespower querymicrosoft fabricpreventcommunity https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Replace-using-Wildcards-ie-Replace-in-Excel-lt-gt/m-p/4266369 Solved: Re: Power Query Replace using Wildcards ie Replace... - Microsoft Fabric Community Nov 7, 2024 - The Text.BetweenDelimiters might be helpfull power querymicrosoft fabricsolvedreplace https://community.fabric.microsoft.com/t5/Custom-Visuals-Ideas-read-only/Power-Query-Editor-Enable-Disable-Load-for-more-than-one-table/idi-p/868431 Power Query Editor - Enable/Disable Load for more ... - Microsoft Fabric Community Nov 27, 2024 - Please make an option to enable/disable load for all selected queries/tables in the powerPivot Window. Currently, we can use this option for only one power queryfor moremicrosoft fabriceditorenable https://community.fabric.microsoft.com/t5/Desktop/desktop-Power-Query/m-p/4849284 Solved: Re: desktop Power Query - Microsoft Fabric Community Oct 17, 2025 - Thankyou, , for your response. Hi HFT, We appreciate your inquiry on the Microsoft Fabric Community Forum. In addition to the response provided by , desktop powermicrosoft fabricsolvedquerycommunity https://community.fabric.microsoft.com/t5/Power-Query/Using-Power-Query-to-Map-my-Excel-Query-Database/m-p/3200944/highlight/true Re: Using Power Query to Map my Excel Query Databa... - Microsoft Fabric Community Sep 28, 2023 - I've played with something similar recently. If you have a table with columns for the From and To values, the Sankey visual should work well in Power power queryto map https://community.fabric.microsoft.com/t5/Desktop/Power-Query-reference-later-added-column/m-p/678146/highlight/true Solved: Re: Power Query reference later added column - Microsoft Fabric Community May 15, 2019 - Great, thanks a lot. Jeremy power querymicrosoft fabricsolvedreference https://community.fabric.microsoft.com/t5/Power-Query/Power-Query-Editor-Dynamic-SharePoint-Links/m-p/2797232 Solved: Re: Power Query Editor Dynamic SharePoint Links - Microsoft Fabric Community power querymicrosoft fabricsolvededitor https://community.fabric.microsoft.com/t5/Power-Query/Power-query-formula-for-adjusting-rounding-in-columns-Multi/m-p/5153597 Solved: Power query formula for adjusting rounding in colu... - Microsoft Fabric Community power query