Calling stored procedures to refresh the SSAS tabular model often results in errors
I have published 4-5 tabular models on the SSAS instance, and I refresh the data of the table model every day after the data warehouse is refreshed. However, they often report errors and the logs cannot identify any problems. Yesterday , last Sunday were successful, and today only one model is successful. What is the reason for this? The SSAS tabular model is a connected MySQL data source, and the error message is as follows: 001 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-001' returned the message 'OLE DB or ODBC error: [DataSource. Error] MySQL: Fatal error encoded during data read...'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 001 '. [SQLSTATE 42000] (Error 50000) This step failed. 003 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed. 003 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-003' returned the message 'The current operation has been canceled because another operation in the transaction failed.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 003 '. [SQLSTATE 42000] (Error 50000) This step failed. 004 Model: The OLE DB provider 'MSOLAP' for linked server 'SSAS-004' returned the message 'OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.'. [SQLSTATE 01000] (Message 7412) Unable to run on remote server 'SSAS_ Execute statement on 004 '. [SQLSTATE 42000] (Error 50000) This step failed. Normally, it takes about 30 minutes to finish job refresh. Looking forward to your reply, thank you.Paginated Report Visual No data in it
I have a paginated report over a Power BI Data set its just a table then I have added a Paginated Report Visual to the Power BI Report There are two Params ParamArea ParamMonth And these look ok However when I bring the table into the page with the two slicers on it, there is no data shows in the paginated Report. I know it woks because there is data when you test the paginated report against the same values in the two slicers. Im not sure what to do now to get this working? Any advice?what is Microsoft powerbi report server sample report datasource credential
I get sample reports from this url:Install Power BI sample reports - Configuration Manager | Microsoft Learn but cannot access sql server without credential. what is the datasource credential in Install Power BI sample reports - Configuration Manager | Microsoft Learn thank you.
Unable to configure with gateway.
I just published my report with input from MySQL. I also installed a gateway and created a new one in app.postman.com. Unfortunately i can not configure my new report and the gateway. When i want to refresh my report fromm app.postman.com i get an error of non authorization. If I try to detect my data it says the gateway is not reachable? What can I do?Unable to connect gateway with datasource
I just published my new report with MySQL as data input. I also created a gateway with this same SQL database. Actually I can not connect those 2 together. If I am looking at the settings from my datafield, i can not select a gateway. Refreshing from app.powerbi.com is not possible now. Any idea how to solve this?
