connect to api with a token
Hi All, I have a dashboard connected to several endpoints of a service(web). There is an authentication (once per 24hrs) and a refresh(hoursly) end points that must be established first. Then use the token to call other endpoints. 1- I made all endpoints separated. all works well with anonymous authentication on desktop, but I cannot schedule refresh on pbi server. error is: [Unable to combine data] Section1/Refresh/Converted to Table references other queries 2- I searched a lot online and solution is to combine queries. I did that and now the third endpoint cannot be refreshed. error is: we couldn't authenticate the credentials provided. ( they are all anonymous and working separately - point 1 senario ) while I put them in one query (see below) the last one's credentials fail. Note: links are samples (for confidentiality purposes) let //Authentication AuthUrl = "https://server/authenticate", AuthContent = " { ""emailAddress"": ""[email protected]"", ""password"": ""passoword"" } ", AuthResponse= Web.Contents(AuthUrl, [ Content=Text.ToBinary(AuthContent), Headers=[#"Content-Type" = "application/json"] ]), AuthJson = Json.Document(AuthResponse), AuthTable = Record.ToTable(AuthJson), RemoveTopRows = Table.Skip(AuthTable,3), FormatRefToken = Table.AddColumn(RemoveTopRows, "Quotes", each """" & [Value] & """"), RemoveExtras = Table.RemoveColumns(FormatRefToken,{"Value"}), TransposedTable = Table.Transpose(RemoveExtras), PromotedHeaders = Table.PromoteHeaders(TransposedTable, [PromoteAllScalars=true]), token = Text.From(List.First(PromotedHeaders[refreshToken])), //Refresh RefUrl = "https://server/party/refresh", RefContent = " { ""refresh_token"": "&token&" } ", RefResponse= Web.Contents(RefUrl, [ Content=Text.ToBinary(RefContent), Headers=[#"Content-Type" = "application/json"] ]), RefJson = Json.Document(RefResponse), RefTable = Record.ToTable(RefJson), AddQuotes = Table.AddColumn(RefTable, "Quotes", each """" & [Value] & """"), #"Transposed Table" = Table.Transpose(AddQuotes), #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]), #"Removed Top Rows" = Table.Skip(#"Promoted Headers",1), #"Removed Columns" = Table.RemoveColumns(#"Removed Top Rows",{"access_token"}), id_token = Text.From(List.First(#"Removed Columns"[id_token])), //Permits Url = "https://server/reporting/permits", Content = " { ""offset"": "&Number.ToText(12)&", ""sort_column"": ""date_create"", ""sort_direction"": ""desc"" } ", Response= Web.Contents(Url, [Headers=[token=id_token,#"Content-Type" = "application/json"]]), Json = Json.Document(Response), ConvertedtoTable = Record.ToTable(Json), Value = ConvertedtoTable{1}[Value], ConvertedtoTable1 = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error), ExpandedColumn1 = Table.ExpandRecordColumn(ConvertedtoTable1, "Column1", {"x", "y", "pz"}) in ExpandedColumn1
Large semantic model refresh timing out: how do you tune partitions and parallelism?
Hi everyone, One of our semantic models has a fact table with around 400 million rows, partitioned by month. A full refresh now runs for several hours and has started to fail near the end. We trigger it with an enhanced refresh request like this: { "type": "full", "commitMode": "transactional", "maxParallelism": 6, "retryCount": 1, "objects": [ { "table": "FactSales", "partition": "2026-10" } ] } What I would like to hear about How do you decide how many partitions to refresh in parallel, given source limits and capacity memory? Do you refresh only the recent partitions and leave older ones alone, or run a periodic full refresh as a safety check? What do you look at first when a long refresh fails late: capacity memory, source timeouts, or the commit step? Settings you changed and the effect they had would be very helpful. Thanks!
Excel Export Errors Occur Frequently in One Power BI Service Workspace but Not Another
Hello, Please excuse any awkward wording, as I am not very comfortable with English and am writing this post with the help of a translation tool. I am experiencing frequent export errors with a Power BI report published to Workspace A in Power BI Service. The exact same PBIX file has also been published to Workspace B, but the report works without any export errors in Workspace B. I have also confirmed that the report works correctly in Power BI Desktop. The settings in Workspace A and Workspace B are basically the same, as far as I can tell. Both workspaces use the same capacity type, and there is plenty of available capacity. The capacity limit is 10 GB, and the current usage is well below that limit. My questions are: What could cause export errors to occur in one workspace but not in another, even when the same PBIX file is used? Are there any workspace-specific settings, service-side limitations, or other factors that I should investigate? Could differences in the semantic model, data source connections, or the Power BI Service environment cause this behavior, even if the workspace settings appear to be the same? Is there anything else I can check to identify the cause of this issue? I would appreciate any suggestions or insights that could help me troubleshoot this issue. Thank you for your help!
Extract the Visual Position of Queries as they appear in the "Workbook Queries" Pane
Hello, Please your help, VBA codes or in Power Quey: Extract the Visual Position of Queries as they appear in the "Workbook Queries" Pane. I have, in Excel 2016 version: A- Workbook, that contains 293 power queries, (lot of tables and lot of names around 2000 each), It does not store store and will never store Macro. B- workbook called MacroStorage, that contains 0 query. it contains all Macros. C- I want to Extract Queries Visual Position as they appear in the "Workbook Queries" pane to the right of excel screen, in the Workbook I designate, select, that contains the Power Queries and dump the main output and the End Summary Output as per the specifications attached as photo and below, in a worksheet I designate, i will imput it, responding to a Prompt, inside the same designated Workbook. ' ==================================== D- The following are the Main outtput Column Names with their Sequence | ColumnSequence| ColumnNames | -------------------------------------- | 1 | QueryName | | 2 | QueryVisualPosition| | 3 | QueryGroup | ------------------------------------- ' =================================== E- Specifications if the specifications here distorted Please the Specifications attached: Macro Refresh All Queries info Output Specifications.png ColumnSequence| ColumnNames | Extracted Output Expected | Columns Wrapped at Width(*) ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 1 | QueryName | Power Query Name | 30 2 | QueryVisualPosition| Position (Numeric) of a query as it appears on the "Workbook Queries" Pane on the right of Excel Screen (**) | 20 3 | QueryGroup | The Query Name as it appears on the "Workbook Queries" Pane on the right of Excel Screen, with the Number of queries inside that Group between brackets []| 16 (*)Later after I have a complete correct Code output, the output visual will dictate and I will update the Column Width required. (**) Please see Sample of "Workbook Queries" Pane attached F- with the following Prompts allowing me to input: 'Prompts List '=== 1. WORKBOOK SELECTION (NUMBERED) === 'List ALL open workbooka and number them 'Open Workbooks : '1: MacroStorage . xlsm '2: Gas stat val Aug 13 2025. xlsx '3: bslddehoqoh.xlsx 'Prompt user to select workbook, where the queries are, number or input its Name. '=== 2. SHEET NAME === 'Prompt for sheet name (no defaults). 'Input worksheet Name where you want to dump the output of this Macro 'option: Cancel '=== 3. CLEAR Designated WorkSheet === 'Prompt for whether to clear existing sheet data before writing. 'Yes No Cancel '=== 4. OVERWRITE HEADERS of Designated WorkSheet === 'Prompt for whether to clear the Header of Designated WorkSheet before writing 'Yes No Cancel '=== 5. SLOW THRESHOLD ===. 'Enter the Time in second if a processing Query depased it Consider Long time 'Set Default Threshold to 1 minute. To be adjusted later based on the result of actual refreshing time '=== 6. FINAL CONFIRMATION === 'The Program MUST Display the list of Prompts ACTUALLY EXECUTED with their Numbers, Not a PrePrinted. 'Ok Cancel '=== 7. Run or Cancel === '10.1. Run '10.2. Cancel ' ========================================================== G- Please stricly following the table specification attached: Please study what is the output Must reveil per columns from the table attached: Please Note: N.1- Do Not Change any Name, or structure, before you ask me, If you want to differentiate version or any, write comment inside the codes. N.2- Please never send Partial or correction code. Only Complete Code. (Ater around 80 hours of trails and failure between you and Deepseek, I am not Reading, because I am learning NOTHING) N.3- Color the output of query row Having any type of issue with each issue different color. N.4- Do not mask any error, let it breaks and we repair it. N.5- Do it Dynamic, no Hardcoding unless in the test. N.6- Create Summary screen of the ACTUAL Prompts EXECUTED with its sequence. Immediate after the Prompts, before "Run" or "Cancel" Icons N.7- Create:Timer/Counter at the bottom left in excel Taskbar. "1 of Total Queries | Time Elapsed 04:49" Allow me to Manually Erase it. N.8- Create three Separate Buttons to: 1. Button to stop Refresh [Stop Refresh], 2. Button to Clear Log [Clear Log] and 3. Button to erase Counter.Timer [Click to Erase Counter.Timer], each between square bracket, and place them 1/10 inch above the Counter.Timer N.11- Later after I have a complete correct Code output, the output visual will dictate and I will update the Column Width required. N.12- Separator is: " ," space and comma N.13- To save time and writing, please Do not Answer till we agree that you receive what I have and all you want. N.14- I intend to use the Correct Macro On Different Workbooks and dumping output into different Workseet Name. N.15- I will run the Macro from Inside the Active Workbook where the Queries are. N.16- Create Report after the Macro Ends Summarizing the extraction, Like the one below: * Later after I have a complete correct Code output, the output visual will dictate the Column Width required **** Never change any Name before you ask me. Want to differentiate, write a comments, inside the codes Separator is: " ," space and comma
Join Tables by Key and Date Comparison
Dear Power Query enthusiasts, Today I am heavily struggling with a join of tables and attributing the lowest milestone date to each row. I searched the web and this forum back and forth but could not find a handle how to solve this problem. In the linked file in the query td_Milestone I have transactional data for 2 project IDs by year and month. Depending on the month a proper month end date is calculated. Taking ID 123 as an example Jan and Feb should receive the joined entry "D1". Mar to Jul "D2". All other Months up to March 2028 shall receive D3. So the join must be a mix of the project ID and a clause of md_Milestone[Dx Date] < td_Milestone[Date] How could this be achieved? I am thankful for any hint into the right direction! Thank you! Best regards, Andreas
User created Sharepoint Calendar as default view, now I can't find the list?
Hello! Basically, I used Get Data --> sharepoint online list --> 2026 Events Calendar Got all the fields. EZ PZ. Since then, they created a Calendar view, which is nice, they can edit the records right there and it's now the default view. Because of this, now when I go to the dataset I created last week, it fails and defaults to the Calendar View, which only uses 4 columns of the 25 ish in allitems. However, I can't find that list anywhere except those 4 columns. I did find the URL, but that doesnt seem to help. I was considering using the API, but it is a last resort. Any thoughts?
