Power BI Refresh Frequency
I hope to display my Power BI report on a screen and refresh it very frequently (e.g. every 5 mins). My report connects to the SQL Server Database (on-premises gateway, "Import" method) and my account is with a Pro license (I do not plan to upgrade to Premium), I'm currently refresh my report 8 times per day. I heard different opinions, some say even the premium lisence can only refresh 48 times per day, some say the "Automatic Page Refresh" enables refreshing at every 1 second (refrence: Real-Time Analytics in Power BI (analytics8.com)). Can Power BI achieve a real-time refreshing with Pro lisence? Thank you in advance!
Power BI report shows expired password despite the password working from the source
Suddenly my report started to display this error whenever I tried to refresh it. It's hooked up to an oracle database which is connected to IFS and I use SQL Dev to modify the database. The password is up to date and working in SQL Dev and I can update the view that Power BI is pulling from but the error comes up when refreshing in Power BI. Is their some way to fix this, I have even tried to re-import the data and it comes up with the error as well?Automatic refresh fails
Hello, I am getting an error message on my programmed report refresh. I am refreshing by gateway (updated to the last version). Using SQL Server. Strange thing is that it has been working perfectly for months, and the last days it stopped working suddenly, and its giving me this message everytime: Mensaje de error subyacente: El archivo o directorio está dañado o es ilegible. DM_ErrorDetailNameCode_UnderlyingHResult: -2147023504 URI de clúster: WABI-PAAS-1-SCUS-redirect.analysis.windows.net Identificador de actividad: 15ee3fd7-77b0-4ab2-aad6-fe3f0ea78025 Identificador de la solicitud: 140459eb-ad7e-4d22-9aa3-80a7eaa05564 Hora: 2022-10-12 22:18:04Z Some one with the same problem?How to refresh ALL dashboards in a specific folder on PBI Report Server ?
Hello, After the deployment of a patch and a refresh of my dataset (a SQL Server), is it possible to refresh ALL dashboards in a specific folder on PBI Report Server ? I have more than 30 of them, and I'm not really into refreshing all of them manually. BR, Sam.Report Refreshing Problem - SQL Server Database
My report was connected to a SQL database with "import" method. It extract data from a stored procedure with an "EXEC spXXXXXX" syntax. I have set a "Scheduled refresh" for 8 times per day. However, when my computer was shut off and SQL Server Management Studio offline, my Power BI report cannot refresh and the scheduler would automatically turned off. In order to keep this report update, I have to keep the SQL Server Management Studio online every morning, somtime I refresh the dataset manually. The error message said "Your data gateway (personal mode) is offline or couldn't be reached." Any solution to this problem?
Refreshing queries is so slow (15 to 20 min)
Hell all, I'm using three csv folders as data sources for my database created in EXCEL with power query. When i refresh my main query, it takes so much time (from 15 to 20 minutes). I guess it is related to the merge function that i used to relate two tables. you'll find below the M code used to merge the two table. Any tips to improve the speed of this query? thank you by advance. let Source = Table.NestedJoin(#"HISTORIQUE MB52", {"CLE", "Date"}, #"UPS STOCK", {"material_Sloc", "Date"}, "UPS STOCK", JoinKind.LeftOuter), #"UPS STOCK développé" = Table.ExpandTableColumn(Source, "UPS STOCK", {"Account", "FSL", "Ref 5 ", "Designator", "UPS QTY"}, {"Account", "FSL", "Ref 5 ", "Designator", "UPS QTY"}), FilterRows = Table.SelectRows(#"UPS STOCK développé", each [UNR] <> 0 or [Blocked] <> 0 or [Returns] <> 0 or [UPS QTY] <> null) in FilterRowsTOO_MANY_DRILL_DOWN_OBJECTS ERROR
Hi Everyone!! I have a dashboard that has their autorefresh set up. It use two data set from SAP. The last 2 months when this report try to refresj gave the following error: Underlying error messageOData: Request failed: The remote server returned an error: (400) Bad Request. (Program error in class CL_RSBOLAP_QV_RESULT_SET method : TOO_MANY_DRILL_DOWN_OBJECT I was looking for ideas to fix it. I checked the characteristics and both data set has lest than 8 characteristics each query. Someone know a way how to fix the problem!! I appreciete idea. Best Regards, Sonia
Broken relationship after RS refresh
Hi I have an issue where resfreshing my data on Report Server breaks one of my datasets relationships to the date table. The relationship is ok when refreshing the data in PowerBI desktop RS. The relationship is ok when saving or overwriting the report to RS. The relationship breaks after any scheduled refresh on RS. (Refresh is reported successfull) e.g. goes from this: to this: I've gone into options and turned off these options Running RS Jan21
