NeilWalker-RBA
2 years agoRegular Visitor
Status:
Accepted
Previously working Direct Query reference no longer works
Hello! A week ago I published a working BI model the Fabric with no issues. This week the Power Query data model in Power BI Desktop Version: 2.123.742.0 64-bit (November 2023) will not load int...
NeilWalker-RBA
2 years agoRegular Visitor
I isolated just those two queries in a new PBIX and couldn't reproduce the error. If I copy all the queries from the problem PBIX into a new PBIX, I get the error on the second load. So first time it processes the queries fine, then I make an adjustment in the data model to force a second load and get the error.
I'm going with corruption\updated DQ rules and rebuilding to avoid DQ references, unless you have any smarter ideas
Cheers
Neil