How do I edit or create new dashboards in Power BI Desktop with incremental refresh set up?

[JanK]

Hey everyone,

I'm currently working on setting up incremental refreshes for a number of existing datasets and reports, and I'm wondering how do I go about editing or creating new dashboards/visuals in existing reports using Power BI Desktop, instead of the app in the browser.

I've figured out how to add new measures, columns and changes in datasets using ALM Toolkit, so there's no issues there, just want to use PBI Desktop to work on existing reports and then publish them.

Thanks in advance!

[v-stephen-msft · Accepted solution]

Hi @JanK ,

The feature that create dashboard is only available in Power BI Service rather than Power BI Desktop, an idea about the feature that directly create dashboard in Power BI Desktop has been submitted in this link, please vote it up.

Currently, you can publish your Power BI Desktop file to Power BI Service following the steps in this article, then create dashboard in Power BI Service to monitor your import data.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@JanK If you want to set incremental refresh setup. You need to do setup for each table on the desktop and then set up a scheduled refresh in power bi service

refer if needed

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/

[JanK]

I already did that. Not for every table, but for the tables with large amounts of data that had proper timestamps in them, so as far as I can tell I've managed to set up the incremental refresh setup properly in my test workspace. It's just that now I'm not sure how to work on those incremental refresh reports from Power BI Desktop specifically, instead of accessing the reports from the browser and then editing and saving changes there. I just don't like to use the browser app to do this kind of work, and I'm not sure if there's any limitations there either.

I tried doing a live connection to the dataset, but I need access to all the existing reports using to make changes/additions to them, and not just access to the dataset.

[amikm]

Hi @JanK, did you try the data refresh of the Power BI dataset using XMLA endpoint. In this case, you can refresh the individual table (say fact table)