Forum Discussion
Data Model Error on Re-Open
I create a Data Model thru Get & Transform Data on Excel 2019.
There's no issue during the Data Model creation.
But the Error pop up show after re opening the file.
It doesn't matter the data load into Data Model only or load into Data Table, it show error.
I looking for your suggestion for it.
mSuroso
- Are you able to create a file that shows this error, but does not contain sensitive data? If yes, please share a link to such a file here.
Dear JKPieterse
Thanks for your response.
Below are the link of file.
https://drive.google.com/drive/folders/1hwHI_tyNgiqZqcxC75c04bBGJKLz3gQ5?usp=share_linkError File Name is Dummy FAK.xlsx
There's 3 files on the FAKE.zip, default Query location is E:\Downloads\FAKE. It's the Query source data.
PS.
- All data is fake data, but I keep the data structure on it.
- Error is happen in Excel 2019 only.
I tried in Excel 2013 also (with Power Query Add-Ins), there's no such of kind this issue. Unfortunately, some of formula that available on the newer becomes error.
Thank you for your response in advance.
- I'm sorry, I don't have an answer for you. It works on my end and I do not have a copy of Excel 2019.
