import mode

4 Topics

Direct Query and Import connection in Power BI Report Server
So i noticed it seems power bi report server only supports import mode (i have a scheduled refresh connection to my live database). I am trying to reduce the file size on the server . Is there an option to switch to direct query like we do on PBI Service?
Solved
opejoseph
3 years ago Place Report Server
554Views
0likes
1Comment
Switch to import mode
I have a problem with the switch from direct Query mode to import mode, I have to qualify fo conditions like "no space" , or "no duplicates" but when I want to delete the duplicates or the spaces in my table it says it can't be done in direct Query mode. So I can't have the conditions to switch to Import mode because I'm the direct Query mode. So I don't know how to do.
Wessvel_hl
3 years ago Place Report Server
588Views
0likes
1Comment
MDX or DAX with using a connection to a power bi dataset
HI,i would like to understand why when i create a report and using report query builder to create simple queries, the query languages that are available are MDX /DAX when it is in import mode ,only mdx when the dataset is in direct query mode. Is there a setting on the pbi tenant ? or it depends on the report builder version? thanks for your time and responses.
Solved
CCCP
3 years ago Place Report Server
8.6KViews
0likes
1Comment
Paginated reports - stored procedures
Hi guys! I am currently working in an enviroment with: - PBRS -import mode - and an ODBC connector to a database that I'm not allowed to name. The problem is that currently we have to load tables with 20-100 million rows of data and sometimes we have columns where 1 cell contains ~20 pages long strings. We were looking for solutions (unfortunatelly Direct Query is not an option with this database and connector) to make the import faster. I have come accross paginated reports and stored procedures. How is this really works with import mode ? The user can choose from parameters and the paginated report only imports the data that is filtered ? Or it imports firstly everything? Thank you for your help in advance and have a nice day!
Solved
PowerDinosaur
4 years ago Place Report Server
3.3KViews
0likes
2Comments