This question already has an answer here: Re-writing Common Table Expression (CTE) to Subquery to make a compatable PowerBI DirectQuery (1 answer) Closed 18 mins ago. I was having an issue with my SQL query running in Power BI. I am trying to use a simple common table expression and my code works fine in […]

This question already has an answer here: Re-writing Common Table Expression (CTE) to Subquery to make a compatable PowerBI DirectQuery (1 answer) Closed 18 mins ago. I was having an issue with my SQL query running in Power BI. I am trying to use a simple common table expression and my code works fine in […]

I was having an issue with my SQL query running in Power BI. I am trying to use a simple common table expression and my code works fine in SQL Server but fails when I try to copy and paste my query into the Advanced Editor in Power BI. Nothing is wrong with the connection I have to the database as other queries I’ve written work fine.

I’m building a Power BI report to track stock and inventory levels for various items across different locations. My data source is the item ledger entry table from Navision stored in SQL Server. This table captures item movements for each date and location.