sql

29 Topics

Error while connecting PostGres to Power BI
I'm trying to connect my Power BI Desktop to Post Gres SQL. I get the following error when I tried to connect. Details: "Loading assembly file 'System.Runtime.CompilerServices.Unsafe, Version=4.0.4.1, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed for data source type 'PostgreSQL'" With the same credentials, im able to connect to the MY SQL workbench
Solved
Gandhar09
2 years ago Place Report Server
4.1KViews
0likes
2Comments
Datamart SQL and SYSDATE
Hi I am looking at developing a datamart and have pulled in tables from Oracle, I want to write a SQL statement for a table using xx_end_date is null or xx_end_date > sysdate This is not working on the datamart SQL. Does anyone have a solution to this? Thanks
Solved
Anonymous
2 years ago Place Report Server
909Views
0likes
2Comments
Remove leavers/users in SQL possible?
Hi all We're cleaning up our licenses and i found a bunch of users, that have still a role assigned but do not work anymore in our company. What did I do? I ran this query, this gave me all the users that are somehow on the Database. select u.UserName, r.RoleName, r.Description, c.Path, c.Name from dbo.PolicyUserRole pur inner join dbo.Users u on pur.UserID = u.UserID inner join dbo.Roles r on pur.RoleID = r.RoleID inner join dbo.Catalog c on pur.PolicyID = c.PolicyID order by u.UserName A couple of them are not anymore working. Is there a way to remove this users via another query or have i to remove them manually from the Power BI Frontend? Many thanks Brani
Solved
Brani
2 years ago Place Report Server
1.6KViews
0likes
7Comments
PowerBI Gateway log sql
I'm having problems with the Powerbi and sql management studio because I can't locate reports or datasets that weigh down my sql server with report queries that are no longer under my control I would like to sparer if there is a way to locate these queries using the dilog files of the powerbi gateway by cross-referencing with the sql activity monitor data
Solved
FrancescoRola
2 years ago Place Report Server
2.3KViews
0likes
5Comments
Report server database is getting larger and larger
hi guys i have a power bi report server and its data base is getting larger and larger. as i had a look on it, the biggest table is CatalogItemExtendedContent. is there anyway to reduce its size buy deleting some useless data? and im wondering what cause this table to be huge in size?
Solved
alisoroush7
2 years ago Place Report Server
2.1KViews
0likes
2Comments
issue with the size of ReportServer database
hi guys. i have a power bi report server. when i go to the sql server directory and data folder i see that te ReportServer data is 44GB however when i run a query in SSMS to see the table size it shows me at most 50 MG! i am wondering that what is the problem?!
alisoroush7
2 years ago Place Report Server
625Views
0likes
2Comments
changing SQL query once pbix loaded to the service
I've loaded a file to the service with the data restricted by the original SQL query importing the data into the PBIX file. I did this because when I ran the whole dataset it has repeatedly failed with a connection termination error at the server side on SQL. Now that I have sucessfully loaded the data into a dataset in my service is there a way I can now change the original SQL statement to remove the where clause filter and so refresh the full dataset in the cloud?
Solved
Parosel
3 years ago Place Report Server
541Views
0likes
1Comment
Encryption Support Message
Hi, I get the following message when I connect to our on-prem SQL database with PowerBI or SSAS: Encryption Support We were unable to connect to the data source using an encrypted connection. To access this data source using an unencrypted connection, click OK So, of course, clicking OK helps and I can connect to the database but I want to get rid of this message or at least understand the consequences of clicking this OK button. I was told, all our connections are secured, but reading this message I'm not so sure As mentioned, everything is on prem and protected by firewall. Authentication is via active directory/Windows. Connecting to the sql server via report server does work without any problem/warning, or does clicking the OK button also surpress any warning on the report server side? thank you!
Solved
whereismydata
3 years ago Place Report Server
17KViews
0likes
4Comments
Serving PDFs From Report
Hello, I have searched all I could and probably I missed something somewhere. To put it simply, what I am trying to achieve is to allow the user to search for documents based on a few columns from an SQL Server (2019 if it matters), give a preview for the PDF, and allow the user to download that PDF. Long version We have an SQL Server that contains contract information and we save the PDFs as a column in a table. I want to be able to create a way for users to search for the document and be able to download it as well. I was able to do two of the three things I want to do. I was able to create the report to allow the user to filter out information in order to locate the report, I was able to use a custom visual PDFViewer to allow the user to preview the PDF, but it seems that there is no "save" function on this custom visual. I thought about doing it using base64 and an HTML custom visual, however in my attempts they either display the encoded file in what appears to be something like an iframe (using HTML Content custom visual) or the error message "Link is malformed" will be thrown (using Shielded HTML Viewer). I know what you are thinking, maybe create a web server to accept a request say with a primary key id in the URL, but the thing is with the way the DoD is going in making everything work from the cloud, they are being more strict in approving on premise servers. I want to first exhaust all options before going through the loops to get a webserver approved. Please let me know if Power BI has no way of doing this, I wouldn't mind. Like I said we can do the webserver solution, but it is my last resort.
Solved
sorcerorkazin
3 years ago Place Report Server
1.1KViews
0likes
1Comment
cannot open .pbix on desktop but can open it online
Hi, My dashboard works online, but after download .pbix I cannot open it on PowerBI desktop. I have set a gateway to the SQL server for powerBI online. Here is the error message on desktop： “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.);No such host is known. The exception was raised by the IDbConnection interface.” If anyone can help thanks a lot. P.S. Happy new year!
Solved
zeppelin
4 years ago Place Report Server
1.2KViews
0likes
2Comments