cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sven2017
Regular Visitor

local PBIX publish to power bi

Hello community,

 

the hole day i tried to publish and refresh a *.pbix file, created with pbi desktop, to power bi online.

Publishing an showing the data was successful.

 

But now i've got some questions:

- Is there a way to keep the published file updated? Means i want to change the pbix file stored on a server inhouse.

Will these changes be updated on the published data online?

- I tried that all with the data gateway solution but always the dataset gets no connection for refreshing.

The on-prem gw is always grey and i cannot choose it.

 

Could yu please help?

 

regards,

Sven

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
sven2017
Regular Visitor

Re: local PBIX publish to power bi

Hello together.

Now it is working!

 

I reinstalled the personal gateway, checked the ports and configured it.

I don't know what the problem was, but i installed the gateway on another server too and got it to work...

 

Refreshing the dataset works fine an all data is up to date.

 

Thank you guys!

 

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: local PBIX publish to power bi

Hi @sven2017

 

If you want to refresh via the Gateway you must first make sure that you got the Gateway installed and configured.

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/

 

Then next you must make sure that where you getting your data from is supported by the Gateway.


If it is then once the Gateway is installed you must configure a data source in Power BI Service and give it a name. That name must be the same name as the data source in your Power BI Desktop file.

 

Below is an example where I connect to a SharePoint On-Premise file which details all of the steps.

 

https://www.fourmoo.com/2017/05/10/power-bi-configuring-sharepointfolder-refreshing-using-on-premise...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog
Moderator v-qiuyu-msft
Moderator

Re: local PBIX publish to power bi

Hi @sven2017,

 

- Is there a way to keep the published file updated? Means i want to change the pbix file stored on a server inhouse.

Will these changes be updated on the published data online?

 

In Power BI service, we can set the schedule refresh for the dataset to make sure the data is updated. Depend on the data sources used in the dataset is on-premise or not, we need to consider use on-premise data gateway or on-premise data gateway (personal mode) act as a bridge between the data source and Power BI service.

 

If we make changes to the pbix file in Power BI desktop, like create a measure, build relationships between tables, etc. We need to republish the pbix file to the Power BI service to get updated.

 

- I tried that all with the data gateway solution but always the dataset gets no connection for refreshing.

The on-prem gw is always grey and i cannot choose it.

 

As @GilbertQ suggested, not all the data sources are supported by on-premise data gateway. You need to check data sources in the dataset, compares with List of available data source types

 

Moreover, you need to check if those data sources really need gateway, you can go through this article to know which data source need gateway: Data refresh in Power BI.

 

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
sven2017
Regular Visitor

Re: local PBIX publish to power bi

Hello together.

Now it is working!

 

I reinstalled the personal gateway, checked the ports and configured it.

I don't know what the problem was, but i installed the gateway on another server too and got it to work...

 

Refreshing the dataset works fine an all data is up to date.

 

Thank you guys!

 

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications