Forum Discussion

Capstone's avatar
Capstone
Icon for Resolver I rankResolver I
4 years ago
Solved

Analysis services live connection creates dataset in service

Hi,   I have a on-prem analysis service tabular model and I connect it live with PBI desktop and publish it to a Gen 2 premium workspace. Im expecting to see only a report but it creates a dataset ...
  • v-luwang-msft's avatar
    4 years ago

    Hi Capstone ,

    Yes. If you publish to Power BI Service from Power BI Desktop ,it will create a dataset.

    And There are five different dataset types, created in the following ways:

    • Connecting to an existing data model that isn't hosted in a Power BI capacity
    • Uploading a Power BI Desktop file that contains a model
    • Uploading an Excel workbook (containing one or more Excel tables and/or a workbook data model), or uploading a CSV (comma-separated values) file
    • Using the Power BI service to create a push dataset
    • Using the Power BI service to create a streaming or hybrid streaming dataset

    Except for streaming datasets, the dataset represents a data model, which leverages the mature modeling technologies of Analysis Services.

     

    To learn more details ,refer: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand 

     

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien