Forum Discussion

pbi-ai's avatar
pbi-ai
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Is it really not possible to publish report changes without overwriting the dataset?

I've got an incremental refresh dataset, this dataset refreshes every 30 minutes. This is in a PPU workspace. The dataset gets it's data from a view in Azure SQL database. The view only retrieves da...
Need Help
  • edhans's avatar
    edhans
    4 years ago

    Not sure. Here is what I did, and it just worked 5min ago.

     

    1. I have the DQ Connection to Power BI Datasets turned on in preview. This isn't necessary but the steps are a bit different.
    2. Saved my full PBIX as Report Name Thin Test.pbix.
    3. Went to Model View. Selected all tables and deleted them.
    4. Connected to Power BI Datasets.
    5. Checked the box next to the dataset I wanted to get all tables (this is what is new in the DQ Dataset preview)
    6. Pressed ok.

    After about a minute, all visuals started working again. Save the file and it is a less than 2MB PBIX file, because virtually nothing is in it.

pbi-ai's avatar
pbi-ai
Icon for Advocate I rankAdvocate I
4 years ago

edhans - That "DirectQuery for Power BI datasets and AS" setting was what I was missing. It worked after this. Thank you very much

 

I see now that this is essentially a live/direct query connection to the dataset itself (the table boxes in the model view have a blue line over it). This really shouldn't affect performance or anything, right? 

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
4 years ago

Correct with one HUGE caveat. If you add additional tables from other datasets into the report, and join them in the composite model, you will see performance issues in these cross-island relationships. 

 

But with one dataset - it is the same thing as a single Power BI dataset. You are just using the model's engine.