Forum Discussion

Mathan's avatar
Mathan
Regular Visitor
8 years ago

How to create a pbix for dynamic data?

I have a REST API server and the data can be fetched using POST call   USER_A enters his own REST API server url and credentials (Username + Password)  USER_B enters his own REST API server url an...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI Mathan,

 

According to your description, you want to achieve dynamic table structure, right ?

 

 

If this is a case, current power bi not support dynamic table structures, each structure need to corresponded with original one who generated by power query operation and cache in query table steps.

 

In summary, when power bi try to load new table structure which can't correspond with previous structure, it will return error message.

 

In my opinion, I'd like to suggest you submit an ideas to add support for dynamic table structure.

 

BTW, power bi not support dynamic column structure(amount, name). (dynamic row amount works)

 

Regards,

Xiaoxin Sheng

Mathan's avatar
Mathan
Regular Visitor
8 years ago

Thanks Anonymous

 

Would it be possible to create content pack with dataset alone, in my case I will create a dataset on the fly (create dataset and add the rows using REST) in the Power BI service using the entered credentials. 

 

My understanding is that the content pack should contain atleast of 1 dataset and 1 report but in my case I don't have report since dataset created on the fly and the end user has to create the report based on the created dataset.

 

All I want is the USER has to enter his credentials and strart building the report based on the created dataset

 

 

In my case both Solution template (pbix) and Content pack (Dataset + Report) are not applicable

 

How do I start developing this without the use Power BI Desktop?

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi Mathan,

     

    For create dataset and push records part, it is possible to develop without power bi desktop.(programming language or other tools who can send/receive httprequests will suitable for these operations)

     

    Logic:

    1. Check dataset, create it if not exist.

    2. Check data table, create it if not contains in above dataset.
    3. Get data table records, push data if no records include.

    4. Get data from specific tables.(operate at power bi desktop side)

     

    Reference links:

    Power BI REST API reference

     

    Get Datasets (check dateset, get dateset object)

    Create Dataset (create dataset and data table)

    Get Tables (check data tables, get data tables)

    Add Rows Delete Rows (operate table records)

     

     

    Notice:

    1. Power br provide c# sample code at official document.
    2. You need a group to achieve above operations.

     

    Regards,

    Xiaoxin Sheng

    • Mathan's avatar
      Mathan
      Regular Visitor
      8 years ago

      Anonymous

       

      My assumption is that I need to create a stand alone Web app, right?

       

      Let's consider I have a web app for the above scenario

       

      1. Will it be listed in the Appsource market place?

      2. Does Appsource market place support web app submission?

       

      Correct me if I am wrong

       

       

      • Mathan's avatar
        Mathan
        Regular Visitor
        8 years ago

        Anonymous

         

        I need to build something similar to Salesforce Reports app in the Get Data -> Services -> Salesforce Reports app and just create a dataset alone

         

         

        My questions are as follows:

         

        1. In the above page it shows list of reports fetched from Salesforce, where should I need to start developing this page where should I start developing?

         

        2. Where I can view the source code for this?

        3. Any documentation available for this?