You cannot publish more than 200 Dataset/Report together within an Workspace in Power BI service

  We have come across an interesting scenario recently while working on one of the customer issues. The issue was not being able to publish the PBIX file to Power BI service in one particular workspace.   The Power BI Desktop shows below error while publishing to service:   Error message:   Well to give…


“Pivot Table Operation failed. We cannot locate a server to load the workbook Data Model” error when applying filter in Excel workbook accessed through Power BI Report server

  Scenario and Issue: – After configuring (by following https://docs.microsoft.com/en-us/power-bi/report-server/excel-oos article) Power BI Report Server to use Office Online Server (OOS) to host the Excel PowerPivot models, when you open the Excel workbook which has the PowerPivot model and try to apply filter or slicer, you get the below mentioned error.   Error: -Pivot Table…


Using Amazon RedShift with Power BI

  Over this blog, I would like to address on how to install the Amazon Redshift Driver on Windows Operating System and how to configure the Data Source Name(DSN) to be used with Power BI.   Creating a System DSN Entry for an ODBC Connection on Microsoft Windows.   After you download and install the…