data refresh

28 Topics

Data Refresh Failed: mysql doesn't support encrypted connections
Hi, I've been trying to fix this problem for a while, and I can't seem to find where the issue is. I have a report connected to Alibaba Cloud's mysql, and everything works fine in PowerBI desktop. I refresh the report and everything is okay. But once I published it to powerbi service and tried to refresh there, I get the following error message: "Data source error: The MySql source doesn't support encrypted connections. (Source at ......). The exception was raised by the IDbCommand interface." Currently, I am not using a data gateway, as I am aware that cloud connections don't require one. I've tried switching between encrypted and not encrypted connections, but the error remains the same regardless of which one I've switched on. I've also tried to use the on-premise data gateway instead, but I can't cuz I'm not an admin user. I am using power query to query the data with the mysql database. Here's the m query code: MySQL.Database("rm XXXXXX", "coordination", [ReturnSingleDatabase=true])
Solved
smallfires0628
1 year ago Place Report Server
7.9KViews
0likes
10Comments
How to refresh the data in an embedded Power BI Report Server Report
We have an on-premise Power BI Report Server. I have created and published a report that I want to embed in a web page, then I set up a scheduled data refresh in the power bi portal to be once every minute, then I embedded the report in an iFrame just like this documentation explains. However, I want to refresh the data visually (the data that appears on the report) just like what the power bi refresh button does (see pic to understand what button I'm referring to) However, the embed link (which we put in the iFrame) does not show this button, is there a way to trigger the refresh every specific time interval (every hour or minute for example) so that the new data appears?
MontherKH
2 years ago Place Report Server
1KViews
0likes
2Comments
Dynamic CRM report, unable to refresh it
Hi team, I have report nameed capture plan, the report is connected to dynamic crm(crm.dynamics.com/api/data/v9) It's last refreshed on 2022, the problem is I am not able to refresh it now, when I am trying to fresh it manually it's giving me option like I don't know how to connect it because I am not familiar with dynamic part what will i need to do to solve this issue, Thank you very much for your attention Best regards
Anonymous
2 years ago Place Report Server
764Views
0likes
2Comments
How can I automatically refresh data in a .pbix file saved on the server?
Hi, I built a PowerBI report that updates the data every month. The data is updated according to the schedule set in Manage/Schedules refresh. In browser it always shows current data. However, when I save the report file to disk locally and then open it in Power BI Desktop, I do not see the current data. The downloaded file contains only the data that was imported when it was saved to the Power BI Report Server. I would like the downloaded file to contain current data. In file I use Data Connectivity mode as Import, because some end users do not have access to the database. Thanks in advance.
Solved
MartaCz
2 years ago Place Report Server
1.3KViews
0likes
3Comments
Refresh -
Currently I have my dataset, and visual on my one drive, I have given access to those files on one drive to my overseas colleage so that he has the ability to update the dataset and refresh the data in Powerbi visual page. When he goes to do the refresh, it fails with an error stating the file cannot be found because it is on my one drive path, even though he has access. How do we both get to access the data and refresh?
Solved
LCarenzo
2 years ago Place Service
3.4KViews
0likes
10Comments
Azure partition refresh issue
Hi all, I am refreshing ds partitions via Azur runbooks and powershell scripts. This week I noticed that the error below appears (previously everything worked fine) This is the line that its calling: $Srv.Connect($connectionString) And the connection string: $connectionString ="Provider=MSOLAP;Data Source=$XmlaEndpoint;User ID=app:$PowerBIServiceApplicationID;Password=$PowerBIServiceApplicationKey;Persist Security Info=True;Impersonation Level=Impersonate" Do you have any suggestions why suddenly this script stoped working a week ago? Thanks in advance!
Misq
2 years ago Place Report Server
441Views
0likes
0Comments
Data Refresh
I am new to Power BI and am experiencing a few issues with my data. When I publish my report from the Power BI desktop to the service, I can see my report and my dataset in my workspace. I have the data tied to a SQL database and the data in the tables gets refreshed via SSIS on a regular basis. I am able to refresh the data in the data view in the desktop and republish it to the service but am not able to refresh it in the service. I can see the error below when try to refresh it fro within the service, but need help understanding what steps to take correct and schedule this. I would appreciate any help as I really have no idea why this isn't working.
peggyh
2 years ago Place Report Server
434Views
0likes
1Comment
MFA refresh issue??
Hi all. I have a strange issue currently happening with a handful of users. When we turn MFA on for our data team, we have an issue refreshing data sets that originate on Sharepoint. My test user is getting the following error: {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SharePoint source are invalid. (Source at https://MYCOMPANY.sharepoint.com/sites/MYCOMPANY/Reporting.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginKind","detail":{"type":1,"value":"SharePoint"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceOriginPath","detail":{"type":1,"value":"https://MYCOMPANY.sharepoint.com/sites/MYCOMPANY/Reporting"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"https://MYCOMPANY.sharepoint.com/sites/MYCOMPANY/Reporting"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"SharePoint\",\"path\":\"https://MYCOMPANY.sharepoint.com/sites/MYCOMPANY/Reporting\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: continents. Power BI is not my forte´ so I'm a little out of depth here. Any help is greatly appreciated. Thanks JD
Solved
Idwal_JD
3 years ago Place Desktop
781Views
0likes
1Comment
Who triggers data refresh on the report
Hi, I want to check who triggered data refresh on the report. On the web portal for the report server, only I can check last refreshed status and date. When I checked ExecutionLogStorage on ReportServer database, I could see the refresh run history by server user name. Is there any other way to check exact user id ?
ey1020_park
3 years ago Place Report Server
448Views
0likes
0Comments
Power Bi Service Cache Error
Hi Everyone I am doing a schedule refresh and I am getting the following error, anyone who can kindly advise? Data source error: We're sorry, an error occurred during evaluation.;The evaluation reached the allowed cache entry size limit. Try increasing the allowed cache size.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: DimDataAgentDetails. Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net Activity ID: 6f4ef2f1-7c3d-4e4c-bfde-5af81f3641fa Request ID: 68b7f84b-1dc9-4e2f-b3d3-8f478ae38dd8 Time: 2023-02-12 14:31:50Z
Anonymous
3 years ago Place Report Server
1.1KViews
0likes
1Comment