Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

BI Desktop Times Out When Trying To Import Excel File

I'm using BI Desktop and trying to import an Excel file into an existing BI report. The Excel file is not password protected and is in the same folder as the .pbix file. The report has a mix of direc...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    Clear permissions in Data source settings of the old .pbix file and try again. If it still fails, you can import this Excel file into a new desktop report first. Then go to Power Query Editor, right click on this query and select copy. Go back to the old report and open Power Query Editor, paste it in Queries pane. In this way, you can copy a query from one report to other reports. Finally apply the changes to Power BI Desktop. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you, Jing. Clearing the Data Source permissions did not work. However, copying the query from a new temporary report to the old one did work. In this case, the copy/paste procedure was the solution. 

v-jingzhang's avatar
v-jingzhang
Community Support
5 years ago

Thank you for the feedback😀