Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi everyone
I faced a weird issue today. I connected one table from the SQL data source to my dataset and suprisingly, it doesn't have all the records. Any idea what is happening?
Solved! Go to Solution.
That was very silly. I tried to add the table by using Get Data>> instead of Recent resources and it fixed!!!
That was very silly. I tried to add the table by using Get Data>> instead of Recent resources and it fixed!!!
@Matt_Gol That's bizarre. Please check below two things,
1 - Click on "Refresh Preview" option and after refresh completion then check the numbers.
2 - Did you check is there any filter applied by any chance at Power Query end.
@Matt_Gol Could you also check if there is any filtered applied in the "Applied Steps" section on the right most pane in Power Query Editor.
No nothing. If I apply any filter here, it does show on advance editor, doesn't it?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |