Forum Discussion

Titatovenaar2's avatar
Titatovenaar2
Advocate II
1 year ago
Solved

Report Pages Disappear When Adding a Local Model

Hi everyone,

We’re experiencing a major issue with our Power BI reports connected via DirectQuery to our main semantic model (star schema with facts/dimensions).

When trying to add an Excel file or custom table to the reports that are connected via DirectQuery to this main model, Power BI prompts us to "Add a local model", which usually worked fine. However, now:

  1. Power BI first asks us to reselect dimensions/facts from the existing model we are connected to via DirectQuery.
  2. After selecting them (or even just one dimension), the entire theme and all report pages disappear.
  3. If we try to proceed without selecting anything, we can't move to the next step.

Has anyone else encountered this or found a solution?

Thanks!

5 Replies

    • Paul_CM's avatar
      Paul_CM
      Frequent Visitor

      Thanks for the link, it worked perfectly.

  • seanify's avatar
    seanify
    Frequent Visitor

    I can't offer a solution, but I will confirm that the exact same thing happened to me yesterday, so you're not alone. In my case I'd only made one visual before I connected the next model so it wasn't an issue really - but yes, that really needs resolving!

  • Paul_CM's avatar
    Paul_CM
    Frequent Visitor

    Hi folks,
    Exact same issue here, all pages disappeared, but I've got a save. I juts wanted to go through with adding the local model.
    Haven't yet tried to roll back but I'm not too stoked about having to go through it.