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.
My dataset is taking a long time to update (I'm on the desktop). Too long, like two hours. I'm importing 10 million rows from an OLTP database (it's not ideal, but it's the only alternative for now). I believe that the delay time is due to the fact that the bank is poorly performing and because it is OLTP, and not because of the performance of my machine. Am I right to think that?
I think that too because I make an equally large query from another server that takes much less time.
Solved! Go to Solution.
How many columns are in each dataset? As @Greg_Deckler it's often more about what is going on in the query and the number of merges and columns than the rows. Power BI is generally ok with lots of rows, but the columns, calculations and merges are what can slow it down.
Have a look at some suggestions in this article to reduce the size of the dataset you're pulling through: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos.
I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query.
https://sites.google.com/site/allisonkennedycv
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
That's generally a long time for 10 million rows although it depends on a number of factors. How compex is your query, any merges, things like that? Any unnecessary things like reordering columns? Perhaps simplify it to just get the raw data in with as little transformation as possible? Have you experimented with the query performance tools?
My query uses only a few JOINS and a WHERE filter. I think this is not complex ... What performance tools do you refer to? I'm new to Power BI and I don't know about these tools.
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |