Forum Discussion

msuroso's avatar
msuroso
Copper Contributor
Mar 27, 2023

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 l...
power bi
JKPieterse's avatar
JKPieterse
Silver Contributor
Mar 27, 2023
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.
  • msuroso's avatar
    msuroso
    Copper Contributor
    Mar 29, 2023

    Dear JKPieterse 

     

    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.  

    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Mar 30, 2023
      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.

Resources