Forum Discussion
Creating a new table in Power BI
Hi everyone, Right now, I am working on a huge datesets. So I have different tables, but I do have a table with the most details in it, and let's call it A. Now, I have updated some new tables an...
Hi
If possible, i would do this in database level as doing this in PBI will hit the performance when the data is huge.
But, lets see if we get any other ideas in this forum.
Thanks
Raj
Anonymous,
Writing custom SQL is your best bet. Both DAX and M code utilizes your computer memory, so writing custom SQL would let the server handle all the heavy lifting
That could be a good try, but what happened if the data are not from the same service, or we just upload all the file into the same service and then write a good sql to get the data we want?