BRK2084-What-is-possible教學講解課件

HybridPowerBI:

Whatispossibleandwhatdoyouneed?WolfgangStrasserBusinessIntelligenceConsultant@cubidoDataPlatformMVPBRK2084PowerBIarchitectureHybridPowerBIWhy?Existingon-premisesinfrastructure(DWH)NotallowedtomovedatatothecloudAfraidofmovingdatatothecloudWhynot?Takethebestapproachesfrombothsides

&combinethem!PathstoHybridPowerBI#1Useon-premisesdatasourcesOn-premisesdatagatewayOn-premisesDatabaseFilesCloudGatewaySystem/en-us/power-bi/service-gateway-onpremDEMO:On-premisesdatagatewayInstallation,configurationSamplereportConfigurationGatewayclusterconfigurationAdministrators(“Whoisallowedtoconfigurethisgateway?”)ContactdetailsDatasourceconfigurationAccessconfigurationUsers(“Whoisallowedtousethisdatasource?”)ForSSAS:Mapusers?Chooseyouraccesstype:Direct/liveconnect

ImportDEMO:On-premisesdatagatewayScheduledrefreshArchitectures/microsoft_press/2016/06/16/free-ebook-introducing-microsoft-power-bi/On-premisesdatagateway:AdministrationOn-PremisesGateway–Administration1/2Whatifyou…..needtosizetheGatewayServer?SizingRecommendations(byKasperdeJonge)/enterprise-gateway-sizing-recommendations/..needtomonitortheGateway?/en-us/power-bi/service-gateway-onprem-tshoot#performance

..wanttoautomateGatewaywork?/en-us/power-bi/service-gateway-high-availability-clusters#powershell-support-for-gateway-clusters

..needtorestarttheGatewayservice?/en-us/power-bi/service-gateway-onprem-tshoot#configuration

..needtomapusernamesforSSAS?/en-us/power-bi/service-gateway-enterprise-manage-ssas#map-user-names

On-premisesgateway—Administration2/2Whatifyou…..needlogginginformation?/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting

..inspectthequeriessentviathegateway?/en-us/power-bi/service-gateway-onprem-tshoot#reviewing-slow-performing-queries

..arelookingfortheGatewayFAQsite?/en-us/power-bi/service-gateway-onprem-faq

..needalistofsupporteddatasources?/en-us/power-bi/service-gateway-onprem#list-of-available-data-source-types

…wanttoadministerallgatewaysinyourtenant?

/

#2SQLserverreportingservices

&PowerBIDEMO:SSRSandPowerBIPinSSRSitemstoPowerBIRDLReportsarecomingtoPowerBI.com/en-us/business-applications-release-notes/April18/power-bi/service/sql-server-reporting-services-ssrs-reports-power-bi-premium

/en-us/businessapplicationssummit/video/BAS2018-2118

#3BringPowerBI(reports)on-premisesPowerBIreportserverSSRSreportsPowerBIreportsCustomVisualizationsMovetothecloudonyourtermsIncludesallSSRSfunctionalityKeepPowerBIreportson-premises/report-server/

PBIRS=SSRS+PowerBIReportsModernlifecyclepolicyYear1Year2Security&CriticalUpdatesSecurityUpdates(Only)Security&CriticalUpdatesSecurityUpdates(Only)Security&CriticalUpdatesSecurityUpdates(Only)Release1Release2Release3SupportEndsNewReleaseFrequentreleases

(planning~3/4peryear)Security&criticalupdatesuntilnextreleaseSecurityupdatescontinueforremainderof12months/en-us/power-bi/report-server/support-timelineDEMO:PowerBIreportserverWhatisit?Reportdevelopment#4ExcelandPowerBIDEMO:ExcelandPowerBIAnalyzeinExcelPowerBIpublisherforExcelPowerBIpublisherforExcelPinExcelitemstoPowerBIdashboardsTablerangesChartsConnecttoPowerBIdatainExcelPBIreportsPBIdatasets->PivotanalysisCostsandlicensingPowerBI.com—On-premisessources/en-us/power-bi/service-features-license-typePowerBIreportserverSQLServerEnterprise

+SoftwareAssurancePowerBIPremiumPowerBIProlicenserequiredtopublishPowerBIreportstoPowerBIReportServer/en-us/blog/power-bi-pro-power-bi-premium-flexibility-to-choose-the-licensing-best-for-you-and-your-organization/

SSRS//RDLinPowerBIPremium//ExcelandPowerBISSRS(PintoPowerBI)EitherSSRS(SQL2016+)ORPowerBIReportServerRDLinPowerBIPowerBIPremiumExcelPowerBIPublisherforExcel->FreeAnalyzeinExcel->PowerBIPROPintoPowerBIHybridPowerBIHybridPowerBI—Chooseyourway(s)On-premisestoPowerBIPowerBItoon-premisesConnecton-premiseswithPowerBIOn-premisesdatagatewayPowerBIreportserverSSRS&ExcelintegrationAboutme—WolfgangstrasserConsultantBusinessIntelligenceandDWH@PowerBI,SQLServer,SSIS,AzureDataServices,ADF,..PowerBIUGLeaderAustria,SQLPassAustriaSQLSaturdayAustriaOrganizerSpeaker,CommunityGuy@wstrasserwolfgang@powerofbi.at

HybridPowerBI:

Whatispossibleandwhatdoyouneed?WolfgangStrasserBusinessIntelligenceConsultant@cubidoDataPlatformMVPBRK2084C