Forum Discussion

ElenaCA's avatar
ElenaCA
Regular Visitor
3 months ago
Solved

Power BI Desktop - No Power BI Datasets Connection

Hello, 

 

I cannot find PBI Detasets connection in PBI Desktop anymore.

 

Do you know what is the issue?

 

Thank you!

 

  • ElenaCA's avatar
    ElenaCA
    3 months ago

    I think the issue is with the mobile version, I am trying to use paramters in a mobile format and there it doesn't work, but I create a new version - a desktop version it works fine 

  • ElenaCA 

    When in "Mobile Layout View" the PowerBI Desktop hides whole bunch of things (including: filter pane, modeling tabl, visual "Build" section). That's normal.

     

    When working in "mobile layout view" you drag&drop visuals you've created in desktop view. 

     

    Try creating the visuals you are trying to get (with field parameters) on the Desktop View. When you are done, switch to Mobile Layout View and drag them to the canvas from the list you will see on the right side (or use Auto Create button, it will do it for you).

    If you managed to make it work in desktop, it will work in mobile view as well.

     

    Check here for short intro on how to add the visuals in mobile view.

    https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-create-mobile-optimized-report-mobile-layout-view?tabs=powerbi-desktop

     

11 Replies

  • HI ElenaCA,

    You’re probably not facing a bug. Microsoft has recently renamed and reorganized some connection experiences in Power BI Desktop.

    The old “Power BI Datasets” connector is now often exposed as :

    • Power BI semantic models
    • or through the OneLake Data Hub / Fabric experience depending on your Power BI Desktop version.

    A few things you can check :

    • Update to the latest version of Power BI Desktop 
    • Look under :
      - Get Data → Power Platform
      - OneLake Data Hub
      - or directly from the Home ribbon via Power BI semantic models
    • Make sure you are signed in with the correct account/tenant.

    Also, Microsoft is progressively replacing the term dataset with semantic model, so the naming difference is expected in newer versions.

    Useful Microsoft docs :

    Hope this helps 
    If it solves the issue, feel free to mark the reply as the accepted solution so it can help others too.

    • ElenaCA's avatar
      ElenaCA
      Regular Visitor

      Thank you! But I am following the steps and I am doing a connection with Power BI Semantic Data Model, but by some reasons the fields parameters are not transfered

      • danextian's avatar
        danextian
        Super User

        Are you connecting via live connection or direct query? Field parameters in the original semantic model do not work in the local copy of the semantic model and must be re-created.

  • I've just tested the live connection to semantic model and I can see the field paramters table and they're working fine.

     

    Are you sure the field parameters you are looking for are actually defined in your semantic model? 

    You can check it by opening the semantic model in the service (if you have access to it). Is the field parameter table visible there?

     

    If it's not there, it might be that the field parameter was created by report developer in report's local model (which in fact created composite model) and are not defined in the semantic model you are connecting to...

     

    You can check your existing reports that use field parameters to confirm what semantic model they are connecting  to. If you see something like that (semantic models connecting one to another) it might mean that the field parameters are defined in the one closer to the report.

     

     

     

    • ElenaCA's avatar
      ElenaCA
      Regular Visitor

      Yes, it is like this, but by some reasons I see parameters names, not the underlying data (and the parameters are also in direct query mode)

       

       

      • PiotrVerde's avatar
        PiotrVerde
        Helper I

        From my experiments I've noticed that:

        The moment you create local model, field parameters created in "remote model" (the one upstream - further from the report) stop to work. 

         

        If your existing reports already use field parameters you want to use and they are working. Make sure you connect live to the same semantic models (the ones that are directly related to original reports). You should be able to use field parameters. but...

        Do not make changes to the model, as this might cause another "local" model to be created and this will become very messy (you will end up with chain of semantic models), and already existing field parameters from the model you connect to will stop to work...

         

        If you need to make changes to the model (this will create local model) you will need to recreate field parameters to utilize them.

        This limitation is actually listed in there (in limitation section): 

        https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

         

        In short words - field parameters need to be defined in the semantic model that is closest to the report, otherwise they won't work.