Forum Discussion

UncleLewis's avatar
UncleLewis
Responsive Resident
4 years ago
Solved

Create a Dataset

Hi,   Using PBIRS Desktop 2.93 May, 2021. How do I create a dataset on Report Server? Everything I find on Google is for Power BI Service.   Thanks -w
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    UncleLewis 

    There is no dataset in Report Server like you understand in Power BI Service. Bacsically, you use Report Configuration to create a database in your SQL server used to save report server data, and then yon can use Desktop for RS create report and save it to the SQL database.

     

    Here is the document for Report Server.

    What is Power BI Report Server? - Power BI | Microsoft Docs

     

     

    Paul Zheng _ Community Support Team
    If this post helps, please Accept it as the solution to help the other members find it more quickly.

ponnusamy's avatar
ponnusamy
Solution Supplier
4 years ago

UncleLewis :

 

You will create the datamodel and visuals/Report using 'Power BI Desktop Optimized for Report Server'. Based on your post you have already installed May 2021. Once you have created a report with dataset, select File -> Save as, you will see an option called "Power BI Report Server" as shown in the screen shot below. Once you select the report server, it will show the report folder where you can publish the report/datamodel.

 

 

You can not reuse the datamodels in Report server as we can reuse datasets from Power BI service., if that's what you are looking for.

 

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.