I have "three" tables in Azure SQL Server:
(The actual names are slightly different and inconsistent; my example is not a misspelling.)
Here's a simplified version of my issue. It returns the correct number of DownloadedBuildingsN, but it only returns 1998 DownloadedRoomsN instead of the full 13360 rows.
Project = 39
Building = DownloadedBuildingsN[@ID]
If I set the last filter to literally any other clause than the ID for DownloadedBuildingsN (or change the formula slightly), it works as expected. I've tried:
BuildingID = ID
BuildingID = DownloadedBuildingsN[@ID]
BuildingID = DownloadedBuildingsN.ID
I suspect this a SQL Server abstraction issue. None of the posts that I've found have been about this problem using Azure SQL Server as the Data Source. But, I hope it's just me misunderstanding.
I will then call SaveData() for offline use.
I've also tried the ForAll-ID-range-divided-by-2000, with the same results.
Session ID: 75dde5f5-30ec-4946-9669-6586fe964668
What am I missing? Thanks.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand