Forum Discussion
NAV Loop tables
Hi PBI Gurus! Is it somehow possible to loop over tables in Power BI by connecting to a NAV Database through a SQL Server? If you look at a G/L Entry table in a NAV databse, then a NAV databa...
Yes that's right.
I have done it before, but I'd have to search to give you and exact answer. I don't have the example here right now.
You have several ways to do it:
- You can use a stored procedure and a cursor to get al the names in the Company table, get the real table name, take only the columns you need, add the Company Name column, and append the rows into one single table.
- Integration services.
- Or you can create a function in Power Query that does the same.
If you get retrieve a small example on the 1 or 3 way, that would be perfect!