Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello 🙂
I am new to powerbi and I am stuck at a problem. I have fetched the data from Azure Tables to PowerBI using SAS connection string as shown below:
But every time the query refreshes, it only loads 397 Rows. And I know there are more than 397 rows because I can also fetch them in Azure Storage Explorer.
Can anyone please help me here and let me know if I have missed anything..? Any help would be really appreciated. Thanks.
@hjoshi4u26 ,I do not think we have such a small limit. Can you share all the power query steps? just want to check if there is any filter in the steps
Hi @amitchandak. I have not applied any filter steps in the Power Query, sharing screenshots below:
Fetching the data from SAS Connection String provides me a single Row of a List. Expanding the List provides me 369 Rows of Records which contains the data from Azure Table Storage.
I have refreshed the data just now and still the problem persists.
Sorry for all the Black Redaction of data, I have to stay ISO compliant (security policy).
Do you know why this occurs..? Every time I refresh the dataset, the rows count stays same 396. Is it possible it is some kind of pagination issue or a countinuation token issue..?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
75 | |
63 | |
62 |
User | Count |
---|---|
135 | |
105 | |
104 | |
80 | |
65 |