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!
Trying to connect to a SQL Database
I am trying to connect to a SQL server database but I keep getting this message: "An exception occurred: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake." My manager connected to the database but this keeps happening when I try. Any suggestions would be great. Thanks
Can't open Microsoft Pubs database
Hi, I am totally new to Power BI and SQL. I am studying a book that uses Microsoft Pubs sample database. I have trying to install this database on my PC for the past three days and for some reason it is not working. I tried every tutorial available online on two PCs and still no luck. The message I have been getting is "an error occurred when attaching the database click the hyperlink in the message." It is worth noting that there is no hyperlink to click at. Any help would be greatly appreciated.
Power BI Report Server - SQL Server Data Source Connection
Hello d_gosbell , I'm currently trying to connect Power BI Desktop (for Report Server) with SQL Server to connect to a data source. IT has provided me the Server details, SQL Statement, and Connection String to input here in Power BI. Once I input the required details here (Server, database, also added a SQL Statement in advanced options). Next, I input the required database user and password. The IT dept has connected the ports to ensure connection is established to the SQL Server. However, after that this error comes up. Kindly assist on how to fix this error. Thanks in advance! Appreciate the support.Credentials-Log into the data source as SQL Server
Hi I am a new power bi user. If someone can solve my issue, I would appricate your support. My issue is that I can not connect to data sources when I enter my ID and password in both window and basic authorization in Power BI Report Server to use sheduled refresh function. Error message is "The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly. Log on failed. Ensure the user name and password are correct." My goal is use Scheduled Refresh fucntion anyway. Below are my current condition. Please let me know if you need other information. -Use SQL Server. I use window authorization when I login SQL Server. I think my ID and password in Power BI Server should be the same as my ID and password to login my Desktop because of using window authorization in SQL Server. I do not create any ID and password for only Power BI. -Use Power BI Report Server. -Create a report via Power BI Desktop and publish it in Power BI Report Server. I can connect to SQL Server in the Power BI Desktop. I do not need my ID and password to connect SQL Server in the case because I use window authorization when I login SQL Server. It automatically makes me login. -I do not have roles of system admistrator and system use, but I have a role of content manager. -Type and Connection string under Connection aleady populated and can not be editted because the report is published in Power BI Report Server. -The message of Scheduled Data Refresh is "Stored credentials for this report are missing. Please go to the Data Sources page for this report and set your credentials for each data source to enable scheduled data refresh." So, import-mode is used instead of direct query.
Order By in VS to represent in Power BI
I am using a SQL Server connection in VS and importing tables. In my table, I have a Date column and then another column that is extracting the Month_Name of the Date column. Example Date Month_Name 01/05/2021 January 03/07/2021 March 08/21/2021 August I used the following script in Advanced Editor in VS to do this: #"Extracted Month Name" = Table.TransformColumns(#"Filtered Rows", {{"Month_Name", each Date.MonthName(_), type text}}) Then when I go to by Power BI dashboard and display the Month_Name in a table, it is not ordering by date, it's ordering alphabetically. (August, January, March) How do I get this column to order by date? (Can't edit the column in PBI since I'm using a VS connector)Scheduled refresh of SQL source but with R script transformstions
Hello. I am exploring using PBIRS as the server to host Power BI reports, which will extract/source data from a SQL Server Database, and which will subsequently use R scripts to transform the data in various ways. Per the link below, as far as I understand R scripts themselves are not a source which can have PBIRS scheduled refreshes applied to them. As such, I'm wondering the following: 1.) Is there a way to work around this so that I can in fact schedule refreshes of a single R script which will hold the code for the entire ETL, 2.) If SQL Server Database is the source and transformations are applied using R scripts, does scheduled refresh work in this scenario? https://docs.microsoft.com/en-us/power-bi/report-server/data-sources#list-of-supported-authentication-methods-for-model-refreshLarge dataset options for reporting server
I'm looking at building a large report (>100M rows) and I can't seem to find a good workign strategy on report server. On premium this is easy using deployment pipelines, or incremental refresh, etc. But what options are there for report server? I.e. how do I have a small working dataset locally (desktop) and the full dataset on the report server?Report not showing visuals with error message on Report Server
Hi, we've deployed a report on the Report server which uses mainly SQL queries to get all the data. When opening the file locally it opens fine with no errors. But once on the Report Server most of the visuals don't load and each say that a relationship can't be found (as per images below). Any help will be greatly appreciated. The connection to the data source is correct as other reports use the same one and are running fine.
