Recent Discussions
SSL certificate error connecting Power BI Service to Supabase (works in Desktop)
Hi everyone, I'm running into an SSL certificate error when trying to connect Power BI to a Supabase (PostgreSQL) database, but only when publishing to the Power BI Service (web). The connection works perfectly fine in Power BI Desktop. What I've already tried, with no success: Changing the connection port Switching the connection/authentication type Installing the SSL certificate locally on my machine Disabling encryption on the connection The same SSL error keeps happening every time I try to refresh/publish through the Service. I'll attach some screenshots of the error below. Here is the exact error message I get: DataSource.Error: An error happened while reading data from the provider: 'The remote certificate is invalid according to the validation procedure.'. Microsoft.Data.Mashup.ErrorCode = 10434. Microsoft.Data.Mashup.ValueError.DataSourceKind = PostgreSQL. DataSourcePath = aws-1-us-east-1.pooler.supabase.com:5432;postgres. . The exception was raised by the IDbCommand interface. Cluster URI WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net Activity ID c92218fd-808b-40e4-9bbf-7b9a9abcd97a Request ID cdb4040f-6e98-4ad9-a64d-0d616cf25d0d Time 2026-09-02 16:08:54Z I know that using an On-premises Data Gateway would likely solve this, but I'd really like to find an alternative solution that doesn't require a gateway, since this is a cloud-to-cloud connection (Power BI Service to Supabase). Has anyone successfully connected Supabase to Power BI Service directly, without a gateway? Any help or pointers would be greatly appreciated! Thanks in advance.
Excel (not Power BI) Power Query — 10 min refresh on 49k rows, need faster iteration
I'm hoping someone can point me in a direction I haven't already tried. I've got an Excel workbook (not Power BI) built entirely on Power Query, and refreshes are taking around 10 minutes or more for a dataset that shouldn't warrant that. Some background: the source data is monthly Activity Statement CSVs downloaded from a broker. Each month I drop a new CSV in a folder — sometimes several times a month — and a master query imports and cleans them, currently sitting at 49,000 rows. That master query is the single source everything else builds from: several derivative queries sit on top of it to log trades and calculate tax figures. It needs to refresh reliably every time a new CSV lands, not just monthly. The workbook file itself is small (under 1MB), so it's not a bloated-file problem. The bigger issue right now: at 10 minutes a refresh, I can't actually develop against this workbook. Adding or adjusting a query means refreshing to see if it worked, and that cost makes iterating on new queries impractical. What I've already tried, which helped but hasn't solved it: Found and fixed a few unbuffered Table.NestedJoin merges where the join input was a table derived through several prior steps rather than a raw source — Power Query was silently re-deriving that whole chain once per row being checked. Wrapping the input in Table.Buffer() first fixed three separate cases, confirmed by timing before and after each one. Tried Queries.FastCombine = True via VBA to bypass the Formula Firewall's privacy-level isolation between sources. Result was inconclusive — still slow. Ruled out simple file bloat given the file size. What I haven't been able to pin down, and would really appreciate input on: I've read (and had confirmed via Microsoft Support) that Excel doesn't share a query-evaluation cache across queries in one refresh the way Power BI Desktop does — if two queries reference the same upstream query, that upstream query gets re-executed once per referencing query, every single refresh. Is there genuinely no fix for this in Excel short of materializing results to a static worksheet table? That trade-off is quite costly for me given the numbers feed tax calculations. Has anyone dealt with row-by-row list/filter operations (e.g. List.Contains against another table's values) being a hidden bottleneck at this kind of row count, versus using a proper anti-join? Any experience with OneDrive sync, COM add-ins, or alternate join algorithms (Table.Join with JoinAlgorithm.SortMerge) actually making a measurable difference in Excel specifically? Excel doesn't have Query Diagnostics (that's Power BI Desktop only, confirmed) — how do people actually profile a slow refresh in Excel without it? I've built a rough VBA macro to time steps manually but would love a better approach. More generally: is there a development workflow people use to avoid refreshing the full chain every time while building new queries on top of a large existing one? Any pointers appreciated — happy to share more detail on the M code if useful.
Live Agent (LA) - API connection to Power BI
Hello, I established API connection to my power BI report. API is from Live Agent (over URL and Api Key) And it work perfect for several queries. BUt now I have another query: Ticket History with following URL: https://geodishyster.ladesk.com/api/v3/tickets/5c81sm9l/history And I need this part of URL: 5c81sm9l to be replace dynamically with Values from My other Query: Query Name: ID's (Ticket ID), Column from that query: ID. SO i can pull all the tickets existing in that list, SO i need some kind of for each / for loop. How to achieve this ? Thank you.Web.Contents failed to get contents from 'https://ausreman.tidywork.com/api/materials' (400)
I have tried a number of scenarios for posting data, but I have come up with nothing. I am trying to write a power query that posts data to a REST API (https://ausreman.tidywork.com/api/materials), it posts data for materials. The current query I have is: = Json.Document(Web.Contents("https://ausreman.tidywork.com/api/materials",[Headers= [#"Authorization"="Basic ZZZZZZZZZZZZZZZZZ",#"Content-Type"="application/json"], Content=Json.FromValue({[projectId="65b6d1fe-ec2e-47c3-9c92-2aad8fdd1d26",userId="67220adb-d5cb-4667-a3ce-ebe3d6248334",materialDateUtc="2015-09-14T07:11:00",materialDate="2015-09-14T17:11:00",materialId="00000000-0000-0000-0000-000000000000",materialLocationId="1aeb9552-a3e9-4804-a7b2-641b290dac8d",materialItemCode="1H3338",materialItemId="f9be8264-81f0-4ae2-a12b-569b3e05d034",costCurrencyId="17709522-6b2e-4b01-9cdf-bb7eb0a43c52",chargeCurrencyId="17709522-6b2e-4b01-9cdf-bb7eb0a43c52",taskId="b2ffc2cf-326a-fc91-eb40-c4ddb4147a35",state="Approved",usageQuantity=1,quantity=1,cost=0.21,charge=0.25]})]), 1252) The only thoughts I had was that it had something along the lines of the size of the data being post. Please help me remove this frustration.
insert values in nested lists except last
I want to insert rows into a list / table , i have used lists here for clarity, but not the last so { { 1,2,3}, {1,2,3} , { 1,2,3} } = { 1,2,3,"X"} , {1,2,3,"X"} , {1,2,3}} I have two methods which work, but would be interested in any other approaches, let Source = { {1,2,3}, {4,5,6}, {7,8,9} , {10,11,12}}, p = List.Positions( List.RemoveLastN( Source,1)) , addlists = List.Transform( p, (x)=> Source {x} & {""} ) & List.LastN( Source ,1) in addlistslet Or Source = { {1,2,3}, {4,5,6}, {7,8,9} , {10,11,12}}, transfrom = List.Transform( Source, (x)=> List.InsertRange( x, List.Count(x), {""} )), result = List.ReplaceRange( transfrom, List.Count( transfrom) -1, 1, List.LastN( Source,1) ) in result I did try putting these in code quotes, but it did not seem to work, so sorry for that. Richard
Using a list as a parameter of an SQL query
Hello. I'm not sure how to use a list as a parameter of an SQL query. The list I have is of integers: I'm trying to use it as a "WHERE IN" parameter inside an SQL query through the advanced editor: let Fonte = Sql.Database("test", "test_readonly", [Query="SELECT *#(lf)FROM TEST tst#(lf)WHERE tst.field IN (" &ProtocolosEquipe10& ")"]) in Fonte What I want to reproduce in the SQL query is: SELECT * FROM TEST tst WHERE tst.field IN (9875825, 9872576, 9870536, 9870530, 9870524, 9870482, 9870455, 9870449, 9870391, 9870383, 9870375, 9870371, 9870159, 9870086, 9870078, 9870074, 9870071, 9869966, 9869845, 9869838) How can I do this without having to generate a parameter inside Power Query?Need Help: Error 8657 accessing Dataverse contact table in Power BI/Excel
Hi Experts, I need your help with this issue (Error 8657 accessing Dataverse contact table in Power BI/Excel). Microsoft Support just responded that it's a backend issue and they're unable to do anything about it. It's been a week since we started getting this error. Please help me to resolve it and guide me on what we can do next. Regards.
Appending columns and creating new column of old column headers
I have a table with data imported from multiple weather stations. The imported data has multiple rows of headers - one row giving the location/ID and one row giving the data variable. I have put an example of how the data looks below. I would like to append the columns so there is one column for rainfall etc from all locations. This would require a new column to identify the location for each row. I have tried to see if I can arrange this with Power Query but I can't find a way to get it to recognise two rows of headers. Or is there another way this can be achieved?Power Query in Excel Fails to Run for Multiple Users
Multiple users are unable to run any Excel Power Query workloads. Error: Could not load file or assembly 'System.Memory, Version=4.0.1.2' Origin: Microsoft.Mashup.Evaluator.Interface Issue affects multiple users and all Power Query refreshes, including simple test queries. Error started on or about August 4th. For reference, current configuration in Excel is: Version 2606 Build 16.0.20131.20150 (64-bit)
