Mar 27 2023 01:39 AM
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
Mar 27 2023 08:57 AM
Mar 29 2023 07:58 AM
Dear @Jan Karel Pieterse
Thanks for your response.
Below are the link of file.
https://drive.google.com/drive/folders/1hwHI_tyNgiqZqcxC75c04bBGJKLz3gQ5?usp=share_link
Error 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.
Mar 30 2023 01:39 AM