Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

POWER BI DESKTOP SOURCE FOR REPORT BUILDER

Hi, I m using power bi desktop with an import mode. I see that I can connect Report builder to SSAS, Power bi Data Set but not from the Desktop itself.   Do you think that Microsoft will allow th...
Desktop source for Report builder
  • AlexisOlson's avatar
    AlexisOlson
    5 years ago

    OK. This might be possible if you have the .PBIX is open since Power BI Desktop is essentially running a local SSAS on your computer.

     

    I've done this in Power Pivot in Excel where the connection looks like this:

     

    I've never tried this from the Report Builder though.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

To clarify, you're trying to connect the Report Builder .RDL to a .PBIX file you have on your local computer as a data source?

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Yes Alexis, when I check the datasource, I can't get "Power bi destkop" as a source.

Then, I have to rebuild my data model on SSAS to do so... 

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    5 years ago

    OK. This might be possible if you have the .PBIX is open since Power BI Desktop is essentially running a local SSAS on your computer.

     

    I've done this in Power Pivot in Excel where the connection looks like this:

     

    I've never tried this from the Report Builder though.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Yeah, very interesting, I saw a Marco Russo video doing something like this, I will try and tell you i if you want.

      Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I forgot to tell you that I am working on Power Bi RS !!