Issue Direct Query with Report
Hello Everybody, We have a PBIRS 2025-01 (Version1.22.9153.7886). I create a report with a Direct Query connection to a SQL Server 2022. There is only 3 tables without relationship All works well in Power BI Desktop for Report Server (query retrieve data and visuals works well). I deployed report on server. When I try to open the report on the Server, there is the error message : When I go to Data Source all works well : We already add a enviornment variable PBI_SQL_TRUSTED_SERVERS on PBIRS with the SQL Server Source but nothing change. Logs on PBIRS shows a szucessful connection (code 200) without any error. Somebody can help me or have an idea to investigate ? Kind Regards, Thomas
Distinct count total is correct, but the columns are not
Hi, I am new to power BI and need some help. I have a list of patient IDs and I want to get the total distinct patients per fiscal year broken down by fiscal period, but when I put it in a table with columns representing the periods, it gives me the distinct total per period not per year, which is not what I want. Only the grand total in the table is correct. e.g. Here is what I'm getting for 2023 (using a slicer): Here's what I want: Again, to clarify, each patient should only be counted once per year, and should only be counted in the first period they appear. In my dates table, I have per row every date from 2022-2025 (Jour"), and the corresponding fiscal period (P#) and fiscal year (Annee 2). In my patient data table, the relevent columns would be the patient ID and appointment date (startdatetime). I have done a lot of research and none of what I've read is giving me the correct results. I can acheive the results when working with imported data, but I need to keep it as direct query so my options are more limited. I would appreciate any help you can give!
Power BI Desktop figures not equal in published in Workspace
I am working on a visual in Power BI desktop (value 3 with 1.41M). However, when I published it in the workspace (no saved bookmarks and no applied filters), the figures are different (value 3 with 1.37M). Values are normalization saved in Sharepoint while the count came from a direct query table from Snowflake. Any idea what happened here? Also when I tried import connection, the table looks the same between desktop and service.
