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 and credentials (Username + Password)

 

The result contains M columns x N rows (for e.g USER_A got 10 columns x 10 rows, USER_B got 1000 columns x 1000 rows), each user have their own data and the column names need not be the same.

 

how should I implement this using a content pack and I found that "template content packs currently require a single report and dataset per content pack" mentioned here.

 

How to create a pbix for the above case?

In my case I don't know the number of fields or the number of entries until is loaded so how do I design the report?

Should I submit an empty/static pbix for submission?

What are the files needs to be submitted along with pbix?

8 Replies

  • 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