Is Microsoft Power BI authorized to use as analytic tool would be integrated with SAP Business One?
Hello Everyone! We're using SAP Business One as an ERP System, and we want to implement Microsoft Power BI project with SAP Business One, that's will be integrated with SAP Business One (SQL Server Database), but unfortunately, I didn't find anything on the internet about if SAP authorized use Power BI as analytic tool, that's will not be integrated directly with SAP Business One but with SQL Server. Thanks in advance.
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.
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!Direct Query SQL connection Report Server
We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly. Got the above error while tring to connect to Microsoft sql server. I was able to connect with import method. However the above error is displayed for Direct Query Method. It is a distributed system with the Report server and Database on different servers. I am uable to connect to the database even if i mannually enter the User Name and password for Windows Authentication. I am using January 2019 desktop app and Report Server.Report Server Reports not useable after n minutes of inactive time
Hi everybody, we mainly have reports which are connected via direct query to SQL Server 2014 databases. Report Server September 2019 is in use. My customer often opens a report, configure it, leave it like this for n minutes (mostly over 10 or 15 minutes) and is returning to it later to reuse it. The issue with PBIRS and this behaviour of my customer is, that the reports are having a timeout so they are not usable until the page is refreshed or the report is opened again. My guess is, that this has something to do with the direct query mode and the connection in the backgorund to the sql server. Is this somehow configurable or fixable? Or is this something the customer has to take because it is a natural behaviour in this situation? Cheers and thanks in advanceReport 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.“An unexpected error occurred” -- Direct Query SQL connection with Enhanced Dataset Metadata
Hi, We get this error from PowerBI Server when we try to run a report with a direct query SQL connection to a SQL Server when the preview feature “Enhanced Dataset Metadata” is enabled. We are running the latest builds (Jan 2021) for PowerBI Desktop and Server. Our workaround currently is to disable the “Enhanced Dataset Metadata” preview feature on the desktop. However, Microsoft has indicated that they “ … aim to make the enhanced format generally available as the only option in the next release of Report Server.” from here. We really need help on this now in order to continue running these reports in the next version of the PowerBI Report Server. Would appreciate hearing from Microsoft Support on this – thanks in advance.Large 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?
