interesting links
410 TopicsVote for "Collapse All" in Power Query
Hi Community, Power Query has no way to collapse all queries at once, so tidying a long list means doing it one by one. I've submitted an idea to add a "Collapse All" option, and it needs votes to get noticed. Vote here (under a minute): 👉 Add "Collapse all / Expand all" to the Queries pane in Power Query Editor | Microsoft Fabric Community Please share it with colleagues who use Power Query. Thank you! 🙏121Views2likes5CommentsPower BI M-Query with TVF execution issue
Dear Team, I have designed a report in Power BI it is art of a Tableau to Power BI migration. I have separated the visuals among three pages with drill through option. It is working as expected but facing a slowness. So I think to use a benefit of M-Query with TVF passing parameter values to make pushdown query. parameter value is a single parameter and accept a comma separated values from 1st page visual. However I have created TVF. TVF is executing properly in DB side. But when I create a bind parameter and associated with my column make it text and enable multi option to get multiple values . Now I write a code snippet let VP=if P_param= null or P_param= "" or P_param= "XXXX" then "ALL" else if Value.Is(P_param, type list) then Text.Combine(List.Transform(P_param, Text.From), ",") else Text.From(P_param), SQL_Query = "SELECT * FROM MY_TVF('" & VP & "')", Source = #table({"Generated_SQL"}, {{SQL_Query}}) in Source This code has been written to check whether the selected parameter from visual VP=1001 is passing properly in TVF. Objective: 1. SELECT * FROM MY_TVF('1001,1002') (if multiple value selected from visual) 2. SELECT * FROM MY_TVF('1001') (if single value is sent) But when I click from visual using drill through feature the TVF is showing always SELECT * FROM MY_TVF('ALL') - The drill through fields when I put in the 2nd page then it is showing proper values . but it is not passing in the TVF so query is not executed it returns blank. My objective is from 1st page matrix visual when I select record one by one accordingly the value will pass and show the result. In matrix 1st column is A1 and A2 is the second column. A1 & A2 are also in drillthrough bucket. A1 can contain multiple A2. so when one A1 is selected then multiple comma separated A2 has been passed in TVF. A2 is an id field. and when A2 column it self selected then single value will pass. But value is not passing and I am not getting the benefit of query pushdown by M-Parameter. The A2 column is parameter binded. it is a text field. P_Param= A2. (bind to A2) . multiple accepted. could you please check and provide any assistance? I have tried all possible options but no results has been encountered. Regards Jishnu BhattacharyaSolved131Views2likes7Commentspasting code
I have just asked a question, and used the code tags, as you would for 'forum', but on viewing it does not look very copy / paste friendly, which was the point of sharing, is there a better way or is there a way to view the entire code as it would appear in a formatter, not much point iin formatting before posting if it's just going to be converted to a single long line RichardSolved91Views2likes3CommentsPower BI semantic model refresh fails in Service, but Gen1 dataflow and Desktop refresh successfully
Hi everyone, my semantic model refresh fails in Power BI Service with this error: DataFormat.Error: The input couldn't be recognized as a valid Excel document. Microsoft.Data.Mashup.ErrorCode = 10311. The exception was raised by the IDbCommand interface. However: The Gen1 dataflow refreshes successfully. The model also refreshes successfully in Power BI Desktop. I’ve reviewed the Power Query queries and couldn’t find any problems. The failure appears to happen only when refreshing the semantic model in Power BI Service. What could cause this difference, and how can I identify the specific query or source triggering the error? Error details: Cluster: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net Activity ID: 76273612-20ed-4ca2-988e-4f593db29fa5 Request ID: 42e32479-4c91-40cf-b83c-e1ebd9591dc4 Time: 2026-09-15 20:18:51 UTC Any help would be appreciated.Solved547Views2likes14CommentsAnti join custom query
Hi community, in ths time., I have two tables A y B, the tbale A have some columns are ID_CITY, ID_STATE, ID_COUNTRY, ID_YEAR, DESCRIPTION_MESSAGE, COUNT_PEOPLE, the other table B the columns are: ID_CITY, ID_STATE, ID_COUNTRY, ID_YEAR, ANNUAL_INCOME, AVERAGE_HEIGH, PERFORMANCE_SCORE, So with the anti right join (ID_CITY, ID_STATE, ID_COUNTRY, ID_YEAR) in power is get the rows than exists in table B but they don't in table A, so with the result create a "new records" with the same structure that table A and append this records in A. is this possible? custom function required? thanks in advance.Solved139Views0likes5CommentsPowerBI connect Salesforce Report Refresh Failure (Intermittent)
I recently gotten a failure notice when I refresh Salesforce Report with PowerBI desktop. It happens at intermittent, sometimes ask for login sometimes won't. Even if inputted my credentials, the login will keep asking again for my login credentials. Previously this does not happen, only until recently which is annoying. I checked my Salesforce Edition is unlimted , API still has lotsa bandwith My Salesforce user profile is not clone. I had done the data source setting to edit every permission 'Public" Can someone suggest or advise alternative solution ? Many Thanks2.7KViews0likes7CommentsQuickly Filter Out Salesforce Object Fields
I have recently connected to Salesforce Object, however my opportunity or account object consist alot of fields. Is there a way to quickly filter out the object fields without writing any advance editior syntax ? The current way that I am doing is by manually removing the object one by one and it is very time consuming.Solved3.8KViews0likes7CommentsDataSource.Error: exceeded 100000 distinct who/what's
Hi , I'd like to connect my report to an online service : Salesforce objects . But I have the following error when I try to reach SFDC object ( work for account ( 250k rows) , opportunities (250k rows) , but not for task ) DataSource.Error: exceeded 100000 distinct who/what's I tried to investigate a bit and discovered that I had to be an Admin user , but I already am ( Local Administrator (Lightning) ) . Any ideas ? TIA :)3.7KViews0likes6CommentsCan't connect to Salesforce Reports
I've been able to connect to our Salesforce objects forever now without issue. I've now encountered a situation where I need to instead connect to reports and it just isn't working. Whenever I try to connect it just sits here and spins and never moves forward: Has anybody ever experienced this? I can't think of what the issue could be.2.1KViews0likes5Comments