DirectQuery with ClickHouse in Power BI Report Server?
Hi everyone, I’m trying to use DirectQuery with a ClickHouse data source in Power BI Report Server. In Power BI Desktop the ClickHouse connector lets me work in DirectQuery mode without any issues. However, the same connector is not available in Power BI Report Server. The ClickHouse documentation (see https://clickhouse.com/docs/integrations/powerbi) suggests using an ODBC connection for the server version, but the ODBC driver only supports Import mode. Because I’m dealing with several billions of rows, Import mode is not feasible for me. Can anyone confirm whether DirectQuery with ClickHouse is possible in Power BI Report Server? If it is supported, could you point me to the required steps or a suitable driver? Otherwise, are there any work‑arounds to achieve near‑real‑time querying on such large datasets? Thank you for your help!
Help with FIFO logic with two Tables in DirectQuery
Hello, I'm struggling with creating a way to measure and/or visualize if a Load Unit that has been delivered to us, was also unloaded first. Deliveries have Priority 1-3 so what we want is, that the first delivery arrived is also the one that is unloaded first. I'm stuck with working in DQ and have to tables to do this- Transports Table and Unloading Table Transports Table has the Columns LoadUnitId, Priority and ActualArrival Timestamp. Unloading Table has the column StarTime Unloading. Something like this: LoadUnitId Priority ActualArrival StartTime Unloading 1234 1 01.01.2025 08:00 01.01.2025 08:15 4321 2 01.01.2025 07:35 01.01.2025 07:56 2134 1 01.01.2025 07:15 01.01.2025 08:19 What kind of expression can be used to check if a Load Unit that has the same priority, was delivered before another one, but unloaded later. I've been thinking of using Ranks but DirectQuery is a bit tricky and won't allow that. Maybe Flags would do the trick but I'm unsure how to use them in this case exactly. Any help would be highly appreciated. Thank you very much 🙂
DirectQuery Impala Connector for Power BI Report Server
According to the documentation, Scheduled Refresh and DirectQuery are not supported for the Impala connector in Power BI Report Server? https://docs.microsoft.com/en-us/power-bi/report-server/data-sources However, in the Power BI Desktop for Report Server, DirectQuery is one of the options for connection. Can anyone clarify if DirectQuery is really supported or not for the Impala Connector in Power BI Report Server? Thanks!DirectQuery from Report Server to remote MSSQL-Server isn't working
Hello Community, i am trying to configure a working DirectQuery from my Report Server to an MSSQL-Server which is not running ob the same server. But i can't figure out how to configure the authentication in the right way. I build an report with DirectQuery in Power IB Desktop, everything works fine. When i publish the report to my report server and start it in the web frontend, i get an error message: An unexpected error occurred. Please try again later. Please try again later or contact support. If you contact support, please provide these details. We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly. At the same time the log of the MSSQL-Server shows an login failure "Login failed for user 'NT AUTHORITY\ANONYMOUS'." from the Report Server. So it seems that my login at the web frontend isn't passed to the MSSQL-Server. I've done some research and found an possible solution in the documentation: https://docs.microsoft.com/en-US/power-bi/report-server/configure-kerberos-powerbi-reports A Domain-Admin helped me to configure the SPNs in the way that the documentation says, but it won't work. Here are some information about the current setup: Server 1: "Domain\Server_MSSQL" Application: MSSQL-Server 2019 (Developer); only Windows-Authentication Instance: default Service "MSSQLSERVER": User "Domain\SQL-Server" Service "MSSQLServerOLAPService": User "Domain\SQL-Server-Analysis" Service "SQLBrowser": User "Local Service" Server 2: "Domain\Server_PBIRS" Application: Power Bi Report Server Jan 2022 (Developer) Service "PowerBIReportServer": User "Domain\PBIRS-Service" PBIRS-User Datenbank: "Domain\PBRIS-DB" PBIRS-User Unattended User: "Domain\PBIRS-Service" (for testing, will be "Domain\PBIRS-Unattended" after Problem is solved) *Server- and Usernames in here are just dummys* We have done the following steps: Edit rsreportserver.config <Authentication> <AuthenticationTypes> <RSWindowsNTLM/> <RSWindowsKerberos/> </AuthenticationTypes> <EnableAuthPersistence>true</EnableAuthPersistence> <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel> <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario> </Authentication> Register SPNs SetSpn -l *Domain\Server_MSSQL* Registered SPN for CN=*Server_MSSQL*,OU=*Datenbank-Computer*: MSOLAPDisco.3/*Server_MSSQL* MSOLAPDisco.3/*Server_MSSQL*.*Domain* WSMAN/*Server_MSSQL* WSMAN/*Server_MSSQL*.*Domain* TERMSRV/*Server_MSSQL* TERMSRV/*Server_MSSQL*.*Domain* RestrictedKrbHost/*Server_MSSQL* HOST/*Server_MSSQL* RestrictedKrbHost/*Server_MSSQL*.*Domain* HOST/*Server_MSSQL*.*Domain* SetSpn -l *Domain\Server_PBIRS* Registered SPN for CN=*Server_PBIRS*,OU=*Computer*: WSMAN/*Server_PBIRS* WSMAN/*Server_PBIRS*.*Domain* TERMSRV/*Server_PBIRS* TERMSRV/*Server_PBIRS*.*Domain* RestrictedKrbHost/*Server_PBIRS* HOST/*Server_PBIRS* RestrictedKrbHost/*Server_PBIRS*.*Domain* HOST/*Server_PBIRS*.*Domain* SetSpn -l *Domain\PBIRS-Service* Registered SPN for CN=*PBIRS-Service*,OU=*Service-User*: HTTP/*Server_PBIRS* http/*Server_PBIRS*.*Domain* SetSpn -l *Domain\SQL-Server-Analysis* Registered SPN for für CN=*SQL-Server-Analysis*,OU=*Service-User*: MSOLAPSvc.3/*Server_MSSQL* MSOLAPSvc.3/*Server_MSSQL*.*Domain* SetSpn -l *Domain\SQL-Server* Registered SPN for für CN=*SQL-Server*,OU=*User*: MSSQLSvc/*SQL-Server* MSSQLSvc/*SQL-Server*.*Domain* Configure Delegations for "Domain\PBIRS-Service" Trust this user for delegation to specific services only Use any authentication protocol Services Service Type User oder Computer Port Service Name MSOLAPDisco.3 *Server_MSSQL* MSOLAPSvc.3 *Server_MSSQL*.*Domain* MSSQLSvc *Server_MSSQL*.*Domain* We think we missed some detail, but can't figure out by ourselfs what it is. So i hope someone can help us to fix it, so i can start installing the productive system.RLS on DirectQuery
Greetings everyone! I'm having trouble configuring the RLS for my report. I've searched several sources on youtube, but nothing has been able to help me. At first I have 2 tables: And I configured the RLS as shown in the image below: When I use EmailBP from BPs por Entidade table in a slicer, I can filter PEOPLE VW_FACT_INDI table normally. However, when I simulate the role in RLS, BPs por Entidade is filtered, but PEOPLE VW_FACT_INDI is not. Why is that? How can I solve this problem? Best Regards,
[Error] Couldn't load the data for this visual in DirectQuery mode
Hello, we are currently encountering an issue regarding data in the "Direct Query" mode: Within the Slicer: If it's single selection, the visualization chart encounters the following error: [OLE DB or ODBC error: [Expression.Error] Unable to fold the expression to the data source, please try a simpler expression] (as shown in picture below). If it's multi-selection, the visualization chart displays correctly. May I ask what could be the cause of this issue?
