Forum Discussion
PowerBI DataFormat.Error:
Hi, RicG22
Thank you very much for your reply. As the error message says, ContosoSalesV31_64bit.accdb' is not a valid path. You should update the path of this file in your Datasource setting. This file should be one of your PBIX data sources, and this error will be reported when Power BI can't read your data：
At the same time, you mentioned that it used to work for a while. Have you tried to open this PBIX in Power Query during your working hours? In addition, I saw that your Datasource setting has a data source path of c/***/contoso.pbix. A PBIX file should not be a data source.
This is the error: DataFormat.Error: Unrecognized database format 'Contoso Corporation.pbix'. Details: The reason why Contoso Corporation.pbix appeared. You have set up a PBIX file as the data source, which is incorrect. A PBIX file is a report and visualization file, not a data source, and can't be imported into Power BI as a data source.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
I appreciate your help but I still couldn't solve the problem. I am going to show the errors in English:
DataFormat.Error: Unrecognized database format 'Contoso Corporation.pbix'. Details: Contoso Corporation.pbix
DataFormat.Error: ContosoSalesV31_64bit.accdb' is not a valid path. Make sure the path is written correctly and that you are connected to the server where the file resides.
Details:
ContosoSalesV31_64bit.accdb
I think it doesn't have to do with the creator only because I opened it and worked on it for some time without any problems. The only two things I did that I didn't want to do was remove 2 columns from the database tables, but I don't think that is a stress for Power BI. This is a school project that I have to send for today.
Hi, RicG22
Thank you very much for your reply. As the error message says, ContosoSalesV31_64bit.accdb' is not a valid path. You should update the path of this file in your Datasource setting. This file should be one of your PBIX data sources, and this error will be reported when Power BI can't read your data：
At the same time, you mentioned that it used to work for a while. Have you tried to open this PBIX in Power Query during your working hours? In addition, I saw that your Datasource setting has a data source path of c/***/contoso.pbix. A PBIX file should not be a data source.
This is the error: DataFormat.Error: Unrecognized database format 'Contoso Corporation.pbix'. Details: The reason why Contoso Corporation.pbix appeared. You have set up a PBIX file as the data source, which is incorrect. A PBIX file is a report and visualization file, not a data source, and can't be imported into Power BI as a data source.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.