server
6 TopicsServer Not Refreshing
Is anyone else encountering an issue with their POWER BI reports not refreshing? My reports have a last refresh date of 3/29 at 5:52am. We have opened service tickets but haven't gotten any help. Can anyone help? I need to run my reports but I need the most recent data.541Views0likes1CommentConnection to PowerBI database not working in report
Hi all, I created a report in the PowerBI desktop (pbix) using excel files as data and a direct query data connection from another PowerBI database. When I publish the .pbix file into the Report Server, all visuals based on the excel files are fine. However for the visuals based on the PowerBI datavase I get this error when the data is loading: Activiteits-id6268f0f0-784c-4a1d-9dee-caf4ac72117a Aanvraag-idc2bae30a-6636-4465-af8b-ab45b4992c9d Correlatie-ida2ac0388-e6eb-0c1a-dec0-53a22b870fe2 TijdTue Jan 31 2023 15:48:37 GMT+0100 (Central European Standard Time) Serviceversie13.0.19866.57 Versie van client2301.2.11954-train URI clusterhttps://wabi-west-europe-d-primary-redirect.analysis.windows.net/ How can I make my visualisations appear again? By the way: I have a PowerBi Premium PU (per user) licence. Regards, Yvonne1.3KViews0likes5CommentsUnable to create connections to Sharepoint: Microsoft.IdentityModel.Tokens.AudienceUriValidationFail
When I try to connect in the web service to pull the files into a datamart, I get an error: Exception of type 'Microsoft.IdentityModel.Tokens.AudienceUriValidationFailedException' was thrown. this SUGGESTS that I'm missing some kind of permissions to create the connection to sharepoint. In this case, I am the owner of the Sharepoint folder. My user is able to access the Sharepoint folder. I am also experiencing issues in the desktop version that might be similar. (Desktop Version: 2.107.841.0 64-bit (July 2022)) I used to be able to create connections to sharepoint via the sharepoint folders connection type. I am no longer able to do this. I get an error that I can't be authenticated with the provided credentials. Further weirdness is that EXISTING connections to sharepoint folders that I've created in the past continue to work. I can also copy the connection information out of an existing sharepoint connection, and repurpose the query, and it works. This is an interesting workaround, but doesn't solve my issue as I need to read this data into a dataflow, or a datamart on the server. Possibly related, I CAN access it via the office365.runtime.auth.authenticationContext in Python. from office365.runtime.auth.authentication_context import AuthenticationContext from office365.sharepoint.client_context import ClientContext from office365.sharepoint.files.file import File from openpyxl import load_workbook url = "https://<org>.sharepoint.com/sites/<site>/" ctx_auth = AuthenticationContext(url) ctx_auth.acquire_token_for_user(<secret>, <secret>) ctx = ClientContext(url, ctx_auth) response = File.open_binary(ctx, "/sites/<site>/<file>")Solved4.6KViews0likes2CommentsTabs along the bottom: Keep server report settings when republish from desktop
From ergonomic resons it is sometime interesting to set the tabs along the bottom instead the lateral side. This can be adjusted in the report setting. However, when a report is republish from desktop (because updates, ...), this setting is removed. Can it be memorized, or can this setting be set from desktop too ?Solved4.6KViews1like4Commentsproblems scheduling an update through a gateway.
Hello, I'm having trouble scheduling a service update through a gateway. I have some PB panels that connect to SQL Server through a custom port. So when I have the panel on PB Desktop, it works perfectly. Now, when I post to PB Online, I am unable to enable an update update. I installed the gateway and it connected perfectly. But when I create the schedule, I get a true credentials error. https://i.ibb.co/9vtyjgq/Suporte-BI1.png https://i.ibb.co/6DGkfkG/Suporte-BI2.png I decided to do a test using a homologation base that configured with a standard of SQL Server 1433 and PB Online updated without problems. Is there any other configuration to be done so that a port other than the standard SQL Server port can be used? Thank you !!!1.4KViews0likes3Comments