data load

3 Topics

Power BI RS Desktop stuck at Evaluating Query for Custom SQL Query
I am importing data from Oracle DB, when I connect to base tables from the source, I am able to successfully load data into PBI RS Desktop. But when I write custom sql code, I am able to see the data in Power Query Window, the moment I hit apply to load the data into the model, PBI RS Desktop gets stuck at Load(Evaluating) for ever.
Solved
Vickar
3 years ago Place Report Server
5.2KViews
0likes
4Comments
Full Reports Not Popping Up
So I was trying to pull up data for a company, but the data is only populating three reports. What the IT team has told me is to return back to a postpage? Not sure how that will help, but I just want all reports there for me and not just a limited form of PowerBI. (ITHELP-200904)
Anonymous
3 years ago Place Report Server
483Views
0likes
1Comment
Loading Data Faster Report Builder
I am not sure I am psoting this is the correct place - this is for PAGINATED REPORT BUILDER I am having some struggles with the data tables/views that my company is having built. First they load Nulls in fields instead of a zero or blank. Best way to build a view for fast access? Paginated report builder does not like this (have to handle these differently). Next is my Paginated reports take a long time to load up the cascading parameters, especially when using views. We are not talking millions of records here, less than 250,000 and sometimes less than 50,000. Any suggestions on what to do to improve table speed and builds for faster data retrieval? Or refer to someone who can help me?
Solved
jrubino77
3 years ago Place Report Server
1.3KViews
0likes
1Comment