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!
On-premises data gateway and New Connection Help!
Good evening, First, let me apologize for the ignorance of my question, but I am at a loss now. Also, I apologize for the length of the post; I want to provide as much helpful information to the community as possible. I am hoping for your assistance. The situation...I have a database file that I have connected to my Power BI desktop app through the use of the ODBC driver. The dataset connects perfectly with no issues, and I use "Windows Credentials" to finish the connection. As you might have guessed, I want to auto-refresh this data to my Power BI app. In order to do this, I have installed and am running the On-Premises data gateway(Not personal). The gateway is up and running, and when I visit my workspace, where I have published the report/dataset I can clearly see the correct data gateway running, but the dataset (the SQLite file) is not correctly configured. I then click on the "add to gateway" button, next to the dataset, to create a new connection between this dataset and the on-premises gateway. I added a connection name, the connect type is correct, "ODBC", the connection string looks correct, and then I selected Authentication Method windows. Here is where I run into issues. For the life of me, I cannot figure out what credentials to use, and I have tried everything. When I first establish the connection in my Power BI desktop, I choose "Use Window Credentials" to connect to the ODBC dataset. Whatever I try, I keep seeing the error invalid credentials. I am figuring I am missing something, or I have not set up some sort of username/password for the dataset, but I would love the help of this community. What am I missing or what credentials should I be using? Thank you