Forum Discussion
Assistance Needed with Power BI Visual for Dynamic Database Switching
Hi pragyas ,
Let's troubleshoot your questions in order below
First, the first error message indicates that the current data source does not support DirectQuery, so it's possible that you're currently using a database with an older compatibility level. You need to upgrade your database version. You can refer to this documentation
KB4093226 - FIX: “DirectQuery may not be used with this data source” error when you browse a Direct Query model in SQL Server - Microsoft Support
Secondly, about pbix file corruption. You can check these documents, one way is you can turn on the automatic recovery option and the other way is you can go to the temporary storage address
CORRUPT PBIX FILE - Microsoft Fabric Community
CORRUPT PBIX FILE - Microsoft Fabric Community
Solved: pbix file is corrupted and can't be opened by Powe... - Microsoft Fabric CommunityBest regards,
Albert HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi pragyas ,
Let's troubleshoot your questions in order below
First, the first error message indicates that the current data source does not support DirectQuery, so it's possible that you're currently using a database with an older compatibility level. You need to upgrade your database version. You can refer to this documentation
KB4093226 - FIX: “DirectQuery may not be used with this data source” error when you browse a Direct Query model in SQL Server - Microsoft Support
Secondly, about pbix file corruption. You can check these documents, one way is you can turn on the automatic recovery option and the other way is you can go to the temporary storage address
CORRUPT PBIX FILE - Microsoft Fabric Community
CORRUPT PBIX FILE - Microsoft Fabric Community
Solved: pbix file is corrupted and can't be opened by Powe... - Microsoft Fabric Community
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly