Forum Discussion
Error importing DBF files when MDX present
I'm trying to import the results from hyraulic simulation software into Power BI Desktop. The output from the hydraulic software is a bunch of .dbf files. I've figured out how to import .dbf files in...
Hello I am with the same error from several machines, except from one. I don't know how to fix it, you were able to move forward with something? Thanks a lot
My best solution was to delete the .mdx files using some Python code at the start of the query. Not ideal because the user must have Python installed, but it works.
= Python.Execute("import os#(lf)#(lf)folderpath=r"""&Text.From(#"Model Output Path")&"""#(lf)#(lf)for parent, dirnames, filenames in os.walk(folderpath):#(lf) for fn in filenames:#(lf) if fn.lower().endswith('.mdx'):#(lf) os.remove(os.path.join(parent, fn))")