Forum Discussion
PowerBI + DAX features
Ruksuro The Desktop is the tool that you will use to author your reports. All DAX, data manipulation, model building, etc. is done in that tool. When you have completed the report, you publish that to the Service. (Publish button in Desktop)
The Service is for sharing, this is where you would build your dashboards or Apps to share with others. There is no ability in the Service to add or modify your model, it shares report building capabilities with the Desktop, but that is it. Its primary function is collaboration and sharing.
Both are part of the complete solution.
Ruksuro First you would need to download a gatway (most likely the On Premises Data Gateway) then you would publish the PBIX file. And in the Service you would schedule a refresh on the dataset.
That is if you use "Import"
If you use the Direct Query connection, then you wouldn't need to schedule any refresh, the dataset would always be up to date because it queries the database directly via the gateway.
Hi Eno, thanks for replying!
So say I build a report locally on desktop based on a database connection, I can then publish this to service for sharing. How is the data then refreshed?
I must be having a slow day!
Ruksuro First you would need to download a gatway (most likely the On Premises Data Gateway) then you would publish the PBIX file. And in the Service you would schedule a refresh on the dataset.
That is if you use "Import"
If you use the Direct Query connection, then you wouldn't need to schedule any refresh, the dataset would always be up to date because it queries the database directly via the gateway.
Appreciate the help Eno, thanks.