Forum Discussion

Lidou_Cand's avatar
Lidou_Cand
Icon for Helper III rankHelper III
6 years ago

Sourcing from Power Bi Report

Hello I hope you are well. I am currently auditing a PowerBi report. There are indicators displayed in the report are false because they do not correspond to those in the data source. I thought of m...
Need Help
Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
6 years ago

Lidou_Cand ,

 

If your report is published on the PBI Service(app.powerbi.com) so, you can use the "Power BI Datasets" option in Get Data in PBI Desktop. So, whatever the data source ingesting in Power BI published report which you wanted to replica will be available in PBI desktop using "Power BI Datasets" option of Get Data.

 

Don't forget to give thumbs up šŸ‘and accept this as a solution if it helped you.

  • Lidou_Cand's avatar
    Lidou_Cand
    Icon for Helper III rankHelper III
    6 years ago

    Hello

    Thank you for your answer.

    I saw that I could only have "PowerBi datasets" in "Direct query" mode.

    Does that mean I can't have multiple data sources in my PowerBi report?

     

    Thanks for your help.

    • Tahreem24's avatar
      Tahreem24
      Icon for Super User rankSuper User
      6 years ago

      Lidou_Cand ,

       

      For example, if your published report has 2 data set so it will display 2 different data sets. Like in below screen shot, I have taken data from Power BI Datasets of published report and this published reports has 2 excel files loaded. So, I can see two excel file in my PBI desktop. Moreover, You can't model this data at PBI desktop. 

       

       

      Don't forget to give thumbs up šŸ‘and accept this as a solution if it helped you.