Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Loading data into power bi - huge dateset

so I have created a view in Oracle, and that view has around 4 million rows of data , i want to build a power bi report based on this view as dataset.   I will have parameters in the report and the...
Need Help
rainer1's avatar
rainer1
Icon for Resolver III rankResolver III
6 years ago

Here is the link in English sry for that 🙂 :

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery#important-considerations-when-using-directquery

 

I think you will get an error like this but not shure because i never tested such ab big table in direct query.

 

"The resultset of a query to external data source has exceeded"

-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks, I will try out power bi service ..i am thinking i can use microsoft ssrs as an alternative solution, as this is adhoc report, are you aware if similar problem exists with microsoft ssrs ?