Forum Discussion
BI Desktop Times Out When Trying To Import Excel File
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.
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.
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.
Thank you for the feedback😀