I have a report called "ABC Dashboard" which works perfectly and the data is refreshed on a daily basis. I also have other reports with Direct Query to this dataset and used to work properly.
Few weeks back, those reports (with DQ to dataset ABC) stopped working suddenly (the parts that contains data from this dataset).
By chance, I had this same dataset in another project (another workspace -- import mode) which is also being refreshed daily, and when I changed the data source for those affected reports to this same dataset but in another workspace, those reports started to work properly with no issues. (I am the admin for all of these reports/workspaces -- pro license)
I ran below test:
In a new pbix file, when I make live connection to ABC dataset, it works just fine. But once I try to add a local model to the same file (composite model), I get below error about dataset "ABC" that "Either the database 'ABC Dashboard' does not exist, or your do no have permissions to access it...'. I have done the same thing before this issue happens with this dataset multiple times with no issues.
I've been receiving this error in past few weeks and haven't been able to find a workaround. I'm using the latest version:
Version: 2.111.590.0 64-bit (November 2022)
I also sent the error through the Power BI desktop to Microsoft, but still nothing back from MS.