please help

9 Topics

Alternate page blank issue in pdf export - Paginated report
Hi, I have created a paginated report and when i export it to pdf format. I am seeing alternate pages are full of blanks. Please help.
Solved
prakash11440278
1 year ago Place Report Server
9.3KViews
0likes
3Comments
Paginated Reports Query
Hello All, I have created the paginated report, and the visual is table which have columns from different tables and no aggragate column is used as columns only few stings based columns are there, when I run it, i gives 1st error as given below and second error is when i remove blank values from column it gives second error. I am using PBI dataset as data source. If i use the some aggregation column in the end it works. Please guide me with this. Thank you in Advance lbendlin amitchandak tamerj1 Greg_Deckler onurbmiguel_
Anonymous
3 years ago Place Report Server
1.2KViews
0likes
5Comments
Import visual custom elements does not work
When I go into the loading element after that it freezes on the loading icon 1. I select an element 2. Freezes on the download icon
dasrealder
3 years ago Place Report Server
841Views
0likes
3Comments
Power BI on Premise not cloud
Hi We have a Power BI Report Server but we using direct query rather than Import Method. Eventually we would like to convert to Import Mode but business says it related to cost because of additional RAM usage. if we would like to optimise the code by writing CTE query method but won't support isn't it? What other query methods we can use to optimise? Please can you explain strong reason why Direct is not better than Import? Direct Disadvantages and Import Advantages.. and also we are not intrested in Live data because all we need is Current Day-1 Data and we are not expecting latest data always because it holds same data in database on whole day.
Solved
Sudhakar510
3 years ago Place Report Server
1.4KViews
0likes
3Comments
Power BI RAM Issues
Hi Experts, We have 64 GB RAM sitting in Server and We have Power BI Reproting Server 99% Reports are direct query and I understand that its not efficient to do it in this way. So with this 99% Directquery Reports RAM Consumtion is like 80% because this is at Testing phase. People develop and test etc For this Direct Query process When running the query it will take RAM Consumption and after result it sits into Power BI Report correct? In Prod it is 30% Consumption for all Direct Query because we have only Release reports in it. Now we would like to move to Import Method and lets say file size is having 500MB. When it refresh it consumes RAM but when it comes into Desktop, while we done with Visual and all, does the data still sits in RAM or Disk? If after refreshing if it sits in RAM that means total RAM Consumption will be 1GB correct? Or Will it sits into Disk after refreshing? Please help as this is very important for us to understand for decission making Is it something related to Increase RAM? Few are saying it will still sit in RAM few are saying still sit in Disk.. not sure.. How can i fix this import method? What should be the standard RAM size in Server?
Solved
Sudhakar510
3 years ago Place Report Server
1.6KViews
0likes
4Comments
Schedule Refresh hitting memory and fails
Hi Currently we have Server Memory Issue I beleive. Previously we used to use direct query and performance is very poor as first time I started using Import Method by using same SQL Script in Advance option. When I refresh in Power BI Desktop it is running successfully (SQL is coming from Pre Prod) and retrieving latest data all good. But when we change the data source to Prod to deploy in server(SQL is coming from Prod) and it is hitting the memory and not refreshing at all and it is failing to get the data. Is it because of Server Memory Size and how can it be fixed. Note:- Power BI desktop is 450 MB and I have 4 SQL Scripts and each script retrieves around 10K of rows which means 40K Rows max. There is no additonal steps in Power Query because all calcualtions done in SQL. Please Help
Solved
Sudhakar510
3 years ago Place Report Server
548Views
0likes
2Comments
Permissions and Users
hello, I have installed tghe Azure PowerBI Report Server, which includes the report server VM and a DC VM. Ive created some reports and posted them to the server, but i cant find any way to add new users and assign them permission to access the reports. Im obviously missing something basic, please help.......
uthall
7 years ago Place Report Server
1.3KViews
0likes
2Comments
Add measure in report builder
Hi everyone I have downloaded report builder. Can someone please tell me where to add measures like sum, Average etc. In it. Thanks
Solved
NISH72
7 years ago Place Report Server
4KViews
1like
2Comments
Running embedded report in Edge browser generates "Hmm, can't reach this page" error
When running our app and pulling up an embedded on-premises Power BI SSRS report that works with Chrome, IE, and Firefox, an Edge browser displays the error page below (btw, nothing happens when I click the "details" link.) Any suggestions?
teros
8 years ago Place Report Server
1.4KViews
0likes
1Comment