PowerQuery not reflecting changes to filenames in Sharepoint Library
Hi All. I've got a simple SPO library with files that I need to query within Excel via PowerQuery, I'm using the Query Type SharePoint List rather than SharePoint Folder because I need other metadata from the library. So far so good, query works great, now the issue, IF I change the filename in the library it does not update in the PowerQuery results. New files will appear OK, other metadata changes appear Version numbers update. Simply the filename will not show the change, Cleared the PowerQuery Cache, that didn't work. File in Library Result in PowerQuery If I create a new Query in a fresh Spreadsheet, same result? Any suggestions greatly appreciated. Cheers Russ
Visual and dax level optimization that causes report slowdown
Hi, I have this visual as attached, that has lot of visual level filters applied it has a dax measure called data completeness as below Data Completeness = var _total = COUNT('Calendar'[Date])*COUNT(Points[DBName-Point_Id]) var _result = [Count of Exisitng Days]/_total return _result It references a dax called Count of Exisitng Days as below Count of Exisitng Days = Var dates = SUMMARIZE(Data, Data[DBName-Point_Id], Data[Date]) Var Ext_dates = COUNTROWS(dates) return Ext_dates Now, the problem I have here is the performance of this visual is causing report to slow down. Please let me know how to optimize the dax and further steps to increase the performance PFA file here PR-419 - Data Coverage - Copy.pbix Thanks in advance! SergeiBaklan
Power query doesn't load all columns
Hello, I'm trying to import a TCD from file 1 to file 2 using Power Qwery to automate it but when I laod the data the new table doesn't have all the colum from the first file. I don't understant what is the isue (I load 10/20 colum). Thanks in advance for your help Kind regard
Performance issues with multiple slicers in "Analyze in Excel" (Power BI Live Connection)
Hi Excel Community, We are experiencing performance challenges when using "Analyze in Excel" connected live to a Power BI Semantic Model, particularly when we have a large number of slicers applied to a Pivot Table. Through our analysis, we've observed that when the "Visually indicate items with no data" option is enabled for these slicers, each slicer interaction seems to trigger at least two additional MDX queries. What's concerning is that these queries appear to run sequentially, meaning that with more slicers, the delay for each filter change becomes significantly longer. We wanted to ask the community if this sequential query execution for each slicer with "Visually indicate items with no data" is the expected behavior in the current implementation of "Analyze in Excel." Has anyone else encountered similar performance issues with multiple slicers in this scenario? If so, have you found any workarounds or best practices to mitigate these delays? We're particularly interested in understanding if there are alternative approaches to achieve the "visually indicate items with no data" functionality without incurring this sequential query overhead. Any insights or experiences you can share would be greatly appreciated. Thanks!Power Query Dropping Decimals with Accounting Format
I'm encountering what seems like a bug in Power Query. I have a table with data that contains numbers with more than 4 decimal places. When this data is in the Accounting format, Power Query is only picking up 4 decimal places, even if the Query is formatting the data is Decimal Number (Changed Type). When the data is formatted as Number, Power Query is able to pick up all decimal places (Some numbers have 10+ decimals) Is this normal behavior? I would like to use the Accounting format because it looks cleaner, but obviously I cannot sacrifice data accuracy. It is also very illogical to have a format labeled "Accounting" only hold 4 decimal places when passed through Power Query I did try restarting Excel multiple times, refreshing queries, the only thing that resolved it was changing the local format to Number.Table visual is not filtered due to dax measure
Hi Team, I have a visual as below: when i filter company as below: Table should give me records for selected company and not any other records. But the table here shows all records which means the filter is not recognized. for example, the site and device slicer shows correct records for filtered company but table is not: I guess the problem is due to the below dax online status: This brings in all records irrespective of the selected slicer. Could you please help me resolve this? Please advise! PFA file here PR0442 - Heatsense Live_V1 - Copy.pbix Thanks in advance! SergeiBaklanDrill through issue for the visual for a field that is included in fields other than X-axis
Hi Team, I have the below line chart in the device page: i want to drillthrough this line chart to a target page called device history that contains the below table: I don't want to drag the Name column from the HeatSense_Catalog table into the X-axis of line chart as thats not requirement. But it is fine if we can use that Name column in other fields like tooltip or y-axis etc. Due to this, i can't find any drill through option in the current line chart visual when i right click any data point. My expected output will contain, a drill through page with only single selected Device name,site name for different Updatedon datetime. Could you please help me resolve this issue? PFA file here PR0442 - Heatsense Live_V1_copy1.pbix tabs: Device and Device history SergeiBaklan
I need help with Pivot Table and Data, Excel
Hi, I have made 2 seperated excel data, 1 from exactly January 2025, and the other one is from the complete data I've received from the company. The problem is both shows different Grand Total when the daily breakdown is exactly the same. And when I do a =SUM on a different cell, the results keep showing they're different. Can you help? I'm really confused. Note: This is a side by side comparison Note: This is when I do my own =SUM Where did I do wrong?"OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELECTED
HELLO , I HAVE OFFICE 365 . FROM 1 MONTH AGO THE BUTTON IN DATA TAB THEN PROPERTIES AND IN IT "OVERWRITE EXISTING CELLS WITH NEW DATA..." GET DESELCTED AUTOMATICALLY AND WHEN WE REFRESH DATA IT GET OVERLAPPED . EARLIER IT WAS WORKING FINE LIKE IN SCREEN SHOT WE HAD SELECTED "OVERWRITE........" TAB BUT WHEN WE PRESS OK AND REOPEN IT IT GET DESELECTED PLEASE HELP ON THIS
