Azure, .NET, SharePoint/Office 365, Power Platform, ADF - Knowledge Base

DataQuery - We are using this to connect data in Power BI. For those areas, where we have limitations to import the entire data in our Power BI file i.e. .pbix, we are using DataQuery there. On the runtime, DataQuery connect the source data, run the query model on the source data, and it display those in our Power BI dashboard in visual format. Let's see what are the data sources supported by DataQuery. Following are the data sources supported by Power BI. While using DataQuery and publish, Power BI Service still creates the dataset (like import), however no data will be save there. Only query parameter with other information will be store which will run on source data. Amazon Redshift Azure HDInsight Spark (Beta) Azure SQL Database Azure SQL Data Warehouse Google BigQuery (Beta) IBM Netezza (Beta) Impala (version 2.x) Oracle Database (version 12 and above) SAP Business Warehouse Application Server SAP Business Warehouse Message Server (Beta) S

Journey started two decades ago, it is growing and Growing - Bill Bear from Microsoft recently announced for SharePoint 2019! Preview will come on summer 2019. By H2 CY18, SharePoint 2019 will be available for customer. Wahoo, great news! SharePoint 2019 will be on-premise and we will have same consistent integration feature with Office 365. Migration path will be through 2016. So if you have SharePoint 2010 or 2013 at your on premise, you need to land at SharePoint 2016 and then switch to 2019. Here the Microsoft articles provides in details about it's new features and other details about SharePoint 2019 -  https://techcommunity.microsoft.com/t5/SharePoint-Blog/Welcome-to-SharePoint-Server-2019-a-modern-platform-for-choice/ba-p/194162 Enjoy SharePoint, enjoy SharePoint 2019!

Power BI is the latest trend to provide you the 360 degree of graphical interface in report dashboard. It involves with great services, app, and connectors to make this work. Two flavor are there i.e. Power BI Services, Power BI Desktop. Power BI Services is browser based and Power BI Desktop is windows apps helps to create your report, data model and then you can publish them on your web dashboard. To Learn more on What is Power BI -  https://docs.microsoft.com/en-us/power-bi/power-bi-overview Here you can found the guided learning path from Microsoft on Power BI -  https://docs.microsoft.com/en-us/power-bi/guided-learning / . Power BI Desktop is very user friendly tool and you can quickly build up the most favorable report within a few clicks. More to know about the Power BI Desktop -  https://docs.microsoft.com/en-us/power-bi/desktop-what-is-desktop One great feature of Power BI is measure. It  is a calculation that exists in your Power BI data model. Here the link will help

A few days back, caught something on Workflow manager configuration issue. Workflow Manager has no interlocking with SharePoint and it is entirely independent entity. The script is pretty straight forward. However, after execution the script, following error was generated and seems like Workflow Manager was not able to get installed on VM. New-SBFarm : The term 'New-SBFarm' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again. At line:38 char:9 + New-SBFarm -SBFarmDBConnectionString $managementCS -InternalPortRangeSta ... + ~~~~~~~~~~ + CategoryInfo : ObjectNotFound: (New-SBFarm:String) [], CommandNotFoundException + FullyQualifiedErrorId : CommandNotFoundException New-WFFarm : An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, lo