Excel Not Refreshing Data from Power BI Semantic Model (Live Connection via XLMA)
Hi everyone, I'm trying to create a fully automated reporting process by connecting an Excel workbook directly to a Power BI semantic model using the XLMA endpoint (live connection). The goal is to have Excel always reflect the latest data from Power BI, without needing to manually export reports or paste tables. I’ve written a script that opens and refreshes the Excel workbook each morning to ensure everything stays up to date. The problem: Even after running the refresh (via script or manually in Excel), the data doesn't actually update. It continues to show outdated values, even though Excel successfully connects to the latest version of the semantic model in Power BI. I've already confirmed with my Power BI team that the semantic model is working correctly and refreshing as expected. Their suggestion is that it's an Excel-side issue. Details: I'm using Excel for desktop (latest version) with a Power BI Pro license. The data is pulled via "Get Data, From Analysis Services" using the workspace connection URL. There are no errors during refresh, but the values don't update. Later on, I sometimes do get error messages but not always and never during the initial refresh. The message is along the lines of: "We couldn’t get data from the external data source. The (blank) session ID cannot be found. Either the session does not exist or has already expired." If I manually rebuild the pivot table, it does pull the correct current data, but that defeats the purpose of automation. Has anyone encountered this issue? Is there a known limitation or workaround for ensuring Excel truly refreshes the live connection to the semantic model? Appreciate any insight or suggestions! Has anyone encountered this issue? Is there a known limitation or workaround for ensuring Excel truly refreshes the live connection to the semantic model? Appreciate any insight or suggestions!
Combine table name with each value in the first column
Hello, I need a little help in Excel. So I have some tables of the following structure scattered across multiple sheets. (Fake data) Nokia Phone model Color 6610i Blue 3310 Yellow I want to gather all the data from every sheet into the following table Manufacturer Model Color Nokia 6610i Blue Nokia 3310 Yellow OnePlus 8 Pro Ultramarine Blue The data table always start on column A. Thanks, Iulian
Pulling out only last names from a list containing two and three word names
I have a question regarding TEXTSPLIT I'm dealing with a spreadsheet with a list of names in column A, some of which have only a first and last name, and some have a middle name as well. John Smith Eric Trevor Madison I need to pull out only the last names from each entry in column A and enter it into column B. How can I do this. Thank you
Date not showing slash(/) symbol
Hi everyone, I'm currently using excel from office 365 lifetime version installed in pc. It seems that when I type a date, for example 01/01/2020, it will register as '1 01 2020'. I have already tried deleting Microsoft office registy then reinstalling. Any suggestions on how to fix this so that it will show '01/01/2020' Screenshot below.
STOCKHISTORY values don't match with actual data
I've been analysing some sheets I've built using STOCKHISTORY (portuguese version HISTÓRICODEAÇÕES) and comparing with actual data (from Google Finance). I've realized that the values are not matching, and they diverge differently over time depending on the stock, always increasing over time. What's going on? For instance, CMIG4 (BVMF):excel formulas guide pdf
hi. is there a pdf book from microsoft with describtion of all excel formulas? like on this page Excel functions (alphabetical) (microsoft.com) i dont have internet sometime and would like to have any pdf guide like this one with me or if there is any other pdf i can load, please let me knoe tooCannot print an Excel file
I updated a file on Excel and when I clicked to print, it said there was an error on HP Envy 5530 series (I believe that was the name I gave it, but thought I'd include all information). I've never had a message keeping me from printing. It said there could be several reasons, not enough memory available, try closing files and programs not using. I found the answer, I had to close EVERYTHING except Edge and excel. This is a new one 😞Setting Cell type format as V or L
I have an XLS that's been produced using python and two columns with dates in. Although the cell format is set to Date my upload to another system fails, investigation has found that this is because the cell 'type' is set to 'l' rather than 'v'. I've found a work around using the Text to Columns function but without using cell("type",A1) formula I wouldn't have found this. So two questions really Is there a way to easily identify / set the cell type in excel without adding in the type formula and using Text to Columns to copy and paste Is there a python command that would force this type to value rather than label? (We'll be moving the system to Java in the future so will this likely do the same thing?)
