BRK2084-What-is-possible教学讲解课件

BRK2084-What-is-possible教学讲解课件HybridPowerBI:

Whatispossibleandwhatdoyouneed?WolfgangStrasserBusinessIntelligenceConsultant@cubidoDataPlatformMVPBRK2084HybridPowerBI:

WhatispossPowerBIarchitecturePowerBIarchitectureHybridPowerBIHybridPowerBIWhy?Existingon-premisesinfrastructure(DWH)NotallowedtomovedatatothecloudAfraidofmovingdatatothecloudWhy?Existingon-premisesinfraWhynot?Takethebestapproachesfrombothsides

&combinethem!Whynot?TakethebestapproachPathstoHybridPowerBIPathstoHybridPowerBI#1Useon-premisesdatasourcesOn-premisesdatagateway#1Useon-premisesdatasourcesOn-premisesDatabaseFilesCloudGatewaySystemOn-premisesDatabaseFilesCloudG/en-us/power-bi/service-gateway-onprem/en-DEMO:On-premisesdatagatewayInstallation,configurationSamplereportDEMO:On-premisesdatagatewayConfigurationGatewayclusterconfigurationAdministrators(“Whoisallowedtoconfigurethisgateway?”)ContactdetailsDatasourceconfigurationAccessconfigurationUsers(“Whoisallowedtousethisdatasource?”)ForSSAS:MapusersConfigurationGatewayclusterc?Chooseyouraccesstype:Direct/liveconnect

Import?Chooseyouraccesstype:DEMO:On-premisesdatagatewayScheduledrefreshDEMO:On-premisesdatagatewayArchitectures/microsoft_press/2016/06/16/free-ebook-introducing-microsoft-power-bi/Architectureshttps://blogs.msdOn-premisesdatagateway:AdministrationOn-premisesdatagateway:AdmiOn-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–AdministOn-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?

/

On-premisesgateway—Administra#2SQLserverreportingservices

&PowerBI#2SQLserverreportingserviceDEMO:SSRSandPowerBIPinSSRSitemstoPowerBIDEMO:SSRSandPowerBIPinSSRDLReportsarecomingtoPowerBI.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

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

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

(planning~3/4peryear)Security&criticalupdatesuntilnextreleaseSecurityupdatescontinueforremainderof12months/en-us/power-bi/report-server/support-timelineModernlifecyclepolicyYear1YDEMO:PowerBIreportserverWhatisit?ReportdevelopmentDEMO:PowerBIreportserverWh#4ExcelandPowerBI#4ExcelandPowerBIDEMO:ExcelandPowerBIAnalyzeinExcelPowerBIpublisherforExcelDEMO:ExcelandPowerBIAnalyzPowerBIpublisherforExcelPinExcelitemstoPowerBIdashboardsTablerangesChartsConnecttoPowerBIdatainExcelPBIreportsPBIdatasets->PivotanalysisPowerBIpublisherforExcelPiCostsandlicensingCostsandlicensingPowerBI.com—On-premisessources/en-us/power-bi/service-features-license-typePowerBI.com—On-premisessourcePowerBIreportserverSQLServerEnterprise

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

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

Aboutme—WolfgangstrasserConsHybridPowerBI:

Whatispossibleandwhatdoyouneed?WolfgangStrasserBusinessIntelligenceConsultant@cubidoDataPlatformMVPBRK2084HybridPowerBI:

WhatispossCompleteyoursessionandconferenceevaluations

throughthemobileapporhttps://aka.ms/MBASeventappPleaseselectMicrosoftBusinessApplicationsSummit

fromthemenuofeventsandthenloginwithyourregistrationcredentials

EvaluatethissessionCompleteyoursessionandconfBRK2084-What-is-possible教学讲解课件BRK2084-What-is-possible教学讲解课件HybridPowerBI:

Whatispossibleandwhatdoyouneed?WolfgangStrasserBusinessIntelligenceConsultant@cubidoDataPlatformMVPBRK2084HybridPowerBI:

WhatispossPowerBIarchitecturePowerBIarchitectureHybridPowerBIHybridPowerBIWhy?Existingon-premisesinfrastructure(DWH)NotallowedtomovedatatothecloudAfraidofmovingdatatothecloudWhy?Existingon-premisesinfraWhynot?Takethebestapproachesfrombothsides

&combinethem!Whynot?TakethebestapproachPathstoHybridPowerBIPathstoHybridPowerBI#1Useon-premisesdatasourcesOn-premisesdatagateway#1Useon-premisesdatasourcesOn-premisesDatabaseFilesCloudGatewaySystemOn-premisesDatabaseFilesCloudG/en-us/power-bi/service-gateway-onprem/en-DEMO:On-premisesdatagatewayInstallation,configurationSamplereportDEMO:On-premisesdatagatewayConfigurationGatewayclusterconfigurationAdministrators(“Whoisallowedtoconfigurethisgateway?”)ContactdetailsDatasourceconfigurationAccessconfigurationUsers(“Whoisallowedtousethisdatasource?”)ForSSAS:MapusersConfigurationGatewayclusterc?Chooseyouraccesstype:Direct/liveconnect

Import?Chooseyouraccesstype:DEMO:On-premisesdatagatewayScheduledrefreshDEMO:On-premisesdatagatewayArchitectures/microsoft_press/2016/06/16/free-ebook-introducing-microsoft-power-bi/Architectureshttps://blogs.msdOn-premisesdatagateway:AdministrationOn-premisesdatagateway:AdmiOn-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–AdministOn-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?

/

On-premisesgateway—Administra#2SQLserverreportingservices

&PowerBI#2SQLserverreportingserviceDEMO:SSRSandPowerBIPinSSRSitemstoPowerBIDEMO:SSRSandPowerBIPinSSRDLReportsarecomingtoPowerBI.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

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

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

(planning~3/4peryear)Security&criticalupdatesuntilnextreleaseSecurityupdatescontinueforremainderof12months/en-us/power-bi/report-server/support-timelineModernlifecyclepolicyYear1YDEMO:PowerBIreportserverWhatisit?ReportdevelopmentDEMO:PowerBIreportserverWh#4ExcelandPowerBI#4ExcelandPowerBIDEMO:ExcelandPowerBIAnalyzeinExcelPowerBIpublisherforExcelDEMO:ExcelandPowerBIAnalyzPowerBIpublisherforExcelPinExcelitemstoPowerBIdashboardsTablerangesChartsConnecttoPowerBIdatainExcelPBIreportsPBIdatasets->PivotanalysisPowerBIpublisherforExcelPiCostsandlicensingCostsandlicensingPowerBI.com—On-premisessources/en-us/power-bi/service-features-license-typePowerBI.com—On-premisessourcePowerBIreportserverSQLServerEnterprise

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

PowerBIreportserverSQLServSSRS//RDLinPowerBIPremium//ExcelandPowerBISSRS(PintoPowerBI)EitherSS