tips and tricks

3717 Topics

Power BI sales dashboard for a small WooCommerce store -Import or DirectQuery?
Hi everyone, I run a small UK laptop store called Techyest and I'm trying to build a simple sales dashboard in Power BI connected to our WooCommerce data via a MySQL export. I want to track daily orders, revenue by product category and stock levels, but I'm not sure whether to use Import mode with scheduled refresh or DirectQuery since our data updates throughout the day. For an ecommerce store with a hundred orders a month, what would you recommend? Any tips on setting this up simply without needing a full data warehouse would be really appreciated!
Solved
amyleon
24 days ago Place Power Query
89Views
2likes
6Comments
Modify Power Query Connection? (SEP 2026 Update)
Hey all, It used to be so that when you clicked on the Source, you would get the pop up and see your SQL query and be able to make changes to it. It's no longer the case after the update? Is it the same for everyone? I have tried clicking 'View Data Source Query' but I am unable to modify it. I can probably make slight changes in Advanced Editor, but the query isn't exactly 'human readable' - I can probably make a minor change, but if I need to make a bigger logic change, I used to be able to delete/replace entire query in the old pop up. What am I meant to do now? or Am I missing something?🤡
Solved
irisgenx
26 days ago Place Power Query
196Views
0likes
5Comments
Power BI automatically normalizing text casing during data load
Hello everyone, I am building a Power BI connector that loads data from a server and have observed an unexpected behavior with text values. For example, the source data contains the following values in the City column: PunE Pune pune PUNE However, after loading the data into Power BI, all values are displayed as PunE, matching the casing of the first occurrence. It appears that Power BI treats text values as case-insensitive and preserves the casing of the first occurrence of a particular text value. My questions are: Is this the expected behavior of Power BI during data loading/modeling? If this is expected behavior, is Microsoft/Power BI working on any changes or improvements to preserve the original casing of text values? Is there any way to preserve the exact casing of each source value? Since I am developing a connector that retrieves data directly from a server, are there any connector-side measures or transformations I can apply to prevent this behavior? I have attached screenshots illustrating the source data and the resulting Power BI output. Excel Table - Name Age City Bhargav 22 PunE Dhairya 22 Pune Abhishek 22 pune Gautam 22 PUNE Power BI Table which is loaded from above excel file - Name Age City Bhargav 22 PunE Dhairya 22 PunE Abhishek 22 PunE Gautam 22 PunE Any guidance on how this can be handled at the connector level would be appreciated.
Solved
KumbharM
26 days ago Place Power Query
140Views
3likes
6Comments
Vote 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! 🙏
DataVitalizer
27 days ago Place Power Query
122Views
2likes
5Comments
Power Query IntelliSense Won't Work
Hello there, The new Power Query editor (Sept 2026 release) IntelliSense won't work. It won't work on advanced editor, formula bar, or even from custom column creation option. I am referring Power BI Version: 2.158.1177.0 64-bit (September 2026). Any update on this?
Solved
CheetahLife
28 days ago Place Power Query
172Views
0likes
3Comments
Power 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 Bhattacharya
Solved
jishnubhattacha
1 month ago Place Power Query
131Views
2likes
7Comments
Power 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.
Solved
Teddddddddddddd
1 month ago Place Power Query
551Views
2likes
14Comments
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.
Ellie2026
1 month ago Place Power Query
164Views
0likes
9Comments
Anti 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.
Solved
Peter_23
2 months ago Place Power Query
140Views
0likes
5Comments
MySQL Connector - Direct Query
Hi Team, From Power BI, I'm using the MySQL connector to connect to the MySQL database. However, I do not see an option to choose the data connectivity mode as DirectQuery. The connector is automatically using Import mode. When I checked the Microsoft documentation, it appears that the MySQL connector is supported only in Import mode. Could you please confirm whether this is expected behavior? Is it true that Power BI does not support DirectQuery connectivity with MySQL using the native MySQL connector? Thanks in advance!
Solved
Sandy_22
2 months ago Place Power Query
250Views
0likes
5Comments