Forum Discussion
Loading large data
Idrissshatila thank you for your suggestions. i have figured it out the issue with slow upload. I was merging another table with the condition and that was slowing my data loading. After removing that step there is no issue in loading my data.
Idrissshatila thank you for the reply, at this stage i am trying to load only one fact table and that is taking long time to load. mine report should analyis langitudinal trand over time (2018-2022). data is static once ina year i may need to upload new data.
Super UserHello Rahulmg2002 ,
so working it as a star schema where you define your variables in dimensions tables and keep in the fact Ids and number values will provide a better performance.
also you could try direct query https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila , my data isin Sharepoint folder. i am not sure if we can do direct query on sharepoint folder?
- Idrissshatila
Hello Rahulmg2002 ,
True, it doesn't support direct query, it should be a relational database Model.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Idrissshatila thank you for your suggestions. i have figured it out the issue with slow upload. I was merging another table with the condition and that was slowing my data loading. After removing that step there is no issue in loading my data.