Recent Discussions
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
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!
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.Need help with a merge query/expand table problem
I have a problem a merge query/expand table not displaying the correct data form the merged query after the table has been expanded. The merge is built around 4 columns in each table, and I have tried it both by connecting by the 4 separate columns, then merging this columns into a single column (the state it is currently in) in case there was a problem with the number of columns linked. Here's an example row from the query I am trying to merge into my main query: Here's the merge query set up: Here's an example of what the data looks like after the merge: But here's what it looks like after the table is expanded to add the PERIOD_INDEX field to the table: It seems that something is going wrong with the expand, because the PERIOD_INDEX value of 2 for this example is somehow becoming a 1 when the table is expanded. What am I doing wrong here?
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.
Ways to connect Power BI with SAP Success factor
Hi Team, I didn't come across any official connection between SAP Success Factor with Power BI. Please help us out is there any connection that we can establish between with SAP Success Factor to generate the reports in Power BI. Looking forward to your response.
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)using sharepoint.contents
When trying to use sharepoint.contents to open a sharepoint folder in power query, we notice that for some users excel files are not recognized when we drill to the folder. But if we change mcode to sharepoint.file the exel files populate correctly. Any reason why sharepoint.contents does not work? We like sharepoint.contents better because it creates a more logical structure in power query. (working with a class of students - for most sharepoint.contents works fine but for a couple the excel files are not recognzied)
