Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Desktop Power BI migrate to Service

Hi there,

 

I have a pro account on Power BI service and want to migrate my desktop reports, calculated columns and calculations to the cloud service.

 

All of my data is in sql databases stored locally.

 

I require daily refreshes.

 

What are some good resources to follow for migrating to the cloud?

1 ACCEPTED SOLUTION
zoloturu
Memorable Member
Memorable Member

Hi @Anonymous,

 

Here are steps to migrate the reports:

  1. Install Data Gateway on your PC/laptop. It is required when your data is stored locally but reports are in a cloud. Here is a link to download it - https://powerbi.microsoft.com/en-us/gateway/ and link to the instruction from Microsoft - https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
  2. Map your Power BI Username with PC login (Windows). Example - http://community.powerbi.com/t5/Service/Report-couldn-t-access-data-source-in-Direct-Query-mode/m-p/340255#M38513
  3. Open your reports in Power BI Desktop and publish them to Power BI Service
  4. Go to each dataset and enter credentials, then set a refresh frequency

 

Regards,

Ruslan

View solution in original post

4 REPLIES 4
zoloturu
Memorable Member
Memorable Member

Hi @Anonymous,

 

Here are steps to migrate the reports:

  1. Install Data Gateway on your PC/laptop. It is required when your data is stored locally but reports are in a cloud. Here is a link to download it - https://powerbi.microsoft.com/en-us/gateway/ and link to the instruction from Microsoft - https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem
  2. Map your Power BI Username with PC login (Windows). Example - http://community.powerbi.com/t5/Service/Report-couldn-t-access-data-source-in-Direct-Query-mode/m-p/340255#M38513
  3. Open your reports in Power BI Desktop and publish them to Power BI Service
  4. Go to each dataset and enter credentials, then set a refresh frequency

 

Regards,

Ruslan

Anonymous
Not applicable

I might urge caution about loading a data gateway onto a computer.  You will definately want it on a server, or something that operates 24/7.  If you are trying to automate daily refreshes, putting it on a computer rather than a server will likely cause you more frustration.

 

Servers also have the advantage of more grunt, to process the mashup engine.  Its also possible they have more data bandwidth to handle any growing needs to handle refresh requests of additional datasets as you grow your reporting solutions.

I can agree with that when your database is not on your drive or you are able to connect to it externally, then you can use Gateway on a server, otherwise when database only locally on your PC - no. 

Anonymous
Not applicable

Yeah if you have the data only on a computer, then you are a little stuck.  Wherever possible, avoid having the data source on a computer.  Get it onto a server, a database, or a cloud provider.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors