How to create a pbix for dynamic data?

[Mathan]

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?

[v-shex-msft]

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]

Thanks @v-shex-msft

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?

[v-shex-msft]

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]

@v-shex-msft

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]

@v-shex-msft

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?

[v-shex-msft]

Hi @Mathan,

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

Nope, it means you need set up one device to host push data application to push data to power bi service.(client or server application all suitable for these requirement) It not mean publish power bi app.

For how to develop one application, you can post to application develop related forum to get further support.

Regards,

XIaoxin Sheng

[Mathan]

@v-shex-msft

I don't get any reply from the developer forum so far.

My question is there was an app called "Salesforce Reports" in the app.powerbi.com, if I click on the link it redirects to an app called "Salesforce"

The id shows like "909545e0-1c5e-44a9-b9db-bae412465c89" for both the apps?

In the description it says it will have the dashboard but "Salesforce Reports" didn't create any dashboard?

[v-shex-msft]

Hi @Mathan,

This is a template content pack users published to power bi service.(you can get it with your datasource to get a copied report based on your records)

For this feature, you can refer to below link:

Author template content packs in Power BI

Regards,

Xiaoxin Sheng