Power BI Report Server Architecture Question
Hey All, We are planning a new architecture, and are considering switching to Power BI from another visualization app. We are also beginning a project to build a new Enterprise Data Warehouse. This new infrastructure ought to cover the following components: SSAS Power BI Report Server SQL Server Database Engine ReportServerDB for Power BI report Server. We have a 4 core SQL Server 2019 Enterprise License with Software Assurance. The current design is as follows: Server A: Hosts -- Power BI Report Server Server B: Hosts -- SQL server Database Engine, SSAS, ReportServerDB (Report Server Catalog) My understanding is that SQL Server Enterprise edition Software assurance provides us licensing for Power BI Report Server in addition to the other services that I mentioned. Will the license cover all servcies for Server A and B as described above? or does Power BI need to be installed on Server B as well? Lastly, Any idea how much overhead ReportServerDB (Report Server Catalog) will require? Our current setup utilizes Tableau, which has an internal Report Server Catalog deployed via PostgreSQL on the same server that Tableau is installed on. It would seem to me that a difference here is that Microsoft is pushing the Report Server Catalog off of Server A to Server B. Is that correct? or am I just completely misreading the documentation? thanks!
How to license splitting Power BI report server
Hi, We current have a single server SQL Server Enterprise Edition running SQL Server, SSAS and PowerBI in a 2 server AG cluster. The business wants to start moving reports from a different system to reporting services, so its not going to be feasible to continue running everything on a single server. My understanding is that if I split the PowerBI Report Server to its own server, it will mean we will need another Enterprise Edition license for the server. We do not want any cloud functionality so I believe the other licensing option is not the way to go. Would it be feasible to split the SQLServer service into its own server using the SQL Server Standard Edition instead, and having it in an AG cluster. Then Power BI and SSAS services will run on the existing Enterprise license on a separate AG cluster. Does this make sense? Apologies if I am using the wrong terminology, hopefully I am still able to convey what I am trying to do. TLDR Running a single server with SSIS, SSAS, SSRS & Power BI. Need to split things up accomodate increased usage, need advise on most cost effective and effective way to achive this. If things go well, may require additional report servers so scale out needs to be taken into account. Any advise would be appreciated. Thanks
Dynamic Exchange Rate architecture and DAX calculation in Power BI
I want to get my amount to change as per currency code selected dynamically. In my FactSales table I have currency and Amount. If user want to see that amount in any currency he select the currency from slicer and my excahnge rate will apply to that amount. I tried below DAX to get dynamic Exchange Rate but no luck: ExchangeRate = CALCULATE(MIN(ExchangeRate[ExcahngeRate]), FILTER(ExchangeRate, AND(AND(AND(MIN(FactSales[TransDate])>=MIN(ExchangeRate[ValidFrom]), MIN(FactSales[TransDate])<=IF(ISBLANK(MIN(ExchangeRate[ValidTo])), DATEVALUE("01-01-2070"), MIN(ExchangeRate[ValidTo]))), MIN(ExchangeRate[FromCurrencyCode]) = MIN(FactSales[CurrencyCode])), MIN(ExchangeRate[ToCurrencyCode]) = FIRSTNONBLANK(ExchangeRate[ToCurrencyCode],1)))) ExchangeRate = CALCULATE(MIN(ExchangeRate[ExcahngeRate]), FILTER(ExchangeRate, AND(AND(AND(MIN(FactSales[TransDate])>=MIN(ExchangeRate[ValidFrom]), MIN(FactSales[TransDate])<=IF(ISBLANK(MIN(ExchangeRate[ValidTo])), DATEVALUE("01-01-2070"), MIN(ExchangeRate[ValidTo]))), MIN(ExchangeRate[FromCurrencyCode]) = MIN(FactSales[CurrencyCode])), MIN(ExchangeRate[ToCurrencyCode]) = FIRSTNONBLANK(ExchangeRate[ToCurrencyCode],1)))) https://drive.google.com/file/d/1BCD3cycq-tNTc9xPEK458dn-BjJj9Qao/view?usp=sharing
Power BI Report server catalog database size (August 2017 preview)
I am trying to find out how to size Power BI Report Server Catalog database. I know Power BI report with "data" is stored in the catalog database and it is rendered via Power BI application on the server. I also know preview version has 50MB data size limit. How is this different than regular SSRS catalog database?PBI enterprise architecture'd?
Some weeks ago i've posted about the integration between PBI and SSRS and how Will they evolve in the future, But i've forgot to ask an important question: as PBI is rapidly evolving, it even seems that it Will eventually integrate SSRS, does it still make Sense to sell it as a simple Bi tool for self service? I think we can all agree that it doesnt make Sense... So, the bottom question is if PBI can (and if it is) grow and evolve to become a BI enterprise solution with an architecture so complete and powerfull such as microstrategy and other tools in the market. Regards
