Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
My DataTable has over 70,000 rows, so can't be recreated as a sheet.
Any ideas or suggestions?
Thanks!
Solved! Go to Solution.
Hi @LYBridges
It is recommended that you consider splitting the data into multiple worksheets. Alternatively, export the data to an intermediate database (such as SQL Server) and then connect to that database from Power BI.
In the meantime, you can also contact Samrtsheet for support to see if they have better insights. Smartsheet Support | Smartsheet
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks so much! I'm using multiple worksheets now. I'll have to see if an intermediate database works better.
Hi @LYBridges
It is recommended that you consider splitting the data into multiple worksheets. Alternatively, export the data to an intermediate database (such as SQL Server) and then connect to that database from Power BI.
In the meantime, you can also contact Samrtsheet for support to see if they have better insights. Smartsheet Support | Smartsheet
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 30 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 67 | |
| 62 |