Data loads in Power query but not to Data Model

[amoghshahane30]

Hello,

I am building a report by fetching data from REST APIs. I can get the data and see the data preview in Power query, however when I try to load the data to data model either by 'Close and Apply' or 'Apply' option, the load fails with error that there is no data received from API. If I go back to Power Query and refresh data preview, data is refreshed again!

Here are the high level steps I'm performing to fetch the data:

1. Generate authentication token

2. Execute a query in a another application via API and get the session ID

3. Fetch URL to dataset from the session ID generated in step 2

4. Get data from URL generated in step 3

Steps 1-3 are clubbed inside a fnuction and function output is the dataset URL.

The options 'Enable load to report' and 'Include in report refresh' are both enabled for step 4.

Can someone point out if I'm missing something? Any help is greatly appreciated!

Thanks in advance!!

Amogh Shahane

[v-zhangtin-msft]

Hi, @amoghshahane30 

Here are a few suggestions that might help resolve the issue:

1. Check the Authentication Token: Ensure that the token has not expired and is valid for the session in which you're trying to load the data.

2. Session ID Validity: Verify that the session ID obtained from the query execution is still active and has not timed out.

3. URL Format: Make sure that the URL generated for the dataset is correctly formatted and accessible.

4. Data Source Settings: In Power BI, check the data source settings to ensure that the credentials are set up properly and that there are no issues with the connection or permissions.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amoghshahane30]

Hello @v-zhangtin-msft ,

Thanks for the suggestions! However, as I mentioned in the original post, I'm getting error only while loading the data to report - I can see the data in Power Query before and after going for the Close and Apply option, so these checks are already taken care of.

Thanks,

Amogh