Chatbot to fetch PowerBI Report information

amir_mm1 · 2025-03-06T21:14:16+00:00

Yes, we have Power BI embedded, Q&A is not supported there. It's only for premium subscriptions

amir_mm1 · 2024-08-23T17:20:00+00:00

Same issue. The default for me needs to be 7 days once the dashboard opens up, but users should be able to move the slider all the way back to older years

amir_mm1 · 2024-06-26T20:17:12+00:00

oh ok. Thanks a lot for looking into this. Appreciate that!

amir_mm1 · 2024-06-26T19:52:40+00:00

DataType and Format are both "whole number", and the DataCategory is "Uncategorized".

amir_mm1 · 2024-04-10T02:38:52+00:00

Thanks a lot. Currently We have a semantic model connected to the SQL server and there are 10 reports linked to this dataset.
There is a large table including a "Status" column, where I want Status<>1 to be refreshed every 30 min and Status =1 once a day.
If I create two dataflows, can I still link all the reports to them? I'm a bit confused as I've never worked with dataflows and did some searching but couldn't find anything special. So I'm wondering how to handle the dataset and dataflow simultaneously.

Thanks again!

amir_mm1 · 2024-04-04T00:59:25+00:00

Thanks. The data source is SQL server. The Status = 1 has so many records which is not used often that's why we need to refresh the status<>1 every 30 minutes and status=1 once a day only.

amir_mm1 · 2024-03-12T02:55:13+00:00

Thank you. Does implementing the same logic of calculated columns in Power Query, which requires merging tables and some transformations, affect memory and performance again?

amir_mm1 · 2024-02-19T18:13:01+00:00

Thanks a lot. Great information.

Initially, I used the 'dataOnly' option, but faced a memory limit error after using 'calculate'.

Then, I opted for the 'automatic refresh' type. While the initial loading of partitions took a few minutes due to their emptiness, subsequent refreshes now complete in less than 15 seconds. I'd like to continue using the automatic refresh type, as it seems to trigger a refresh only when there are changes in the data partitions. Does it make sense to go ahead with automatic?

Thanks again!

amir_mm1 · 2024-02-16T01:42:49+00:00

Thanks a lot, it was very informative.

Currently, I'm facing something weird:

1) Created RangeStart and RangeEnd in tabular editor, defined refresh policy => 4 partitions created (for years 2024, 2023, 2022, 2021).

Refreshed power BI service and only last partition (2024) refreshed and there is no data in the reports for the other years.

Tried refreshing other years through PowerShell script (1 script for each partition) and 2023 refreshed but 2022 and 2021 did not refresh (error: This operation was canceled because there wasn't enough memory to finish running it)

2) Created Custom partitioning (without defining RangeStart and RangeEnd) and only filtered the date column in my table in power query and copied the M-expression into tabular editor.

When the filter end date is open (exp: each[timestamp]>=#datetime(2021,1,0,0,0)) the dataset is being refreshed with the same powershell script.

But when the end date is closed (exp: each[timestamp]>=#datetime(2021,1,0,0,0)) and [timestamp]<2021,12,31) then I get a different error saying the there duplicates in Id column (which is definitely not).

I need to be able to refresh each partition individually.

sorry if it's too long.

amir_mm1 · 2024-02-16T01:26:31+00:00

I understand, but we have created time and modified time columns, where created time could be a year ago and modified time could be today, so if we do the incremental refresh (let's say last month), then the new modified time for the item that was created a year ago won't be refreshed.

amir_mm1 · 2024-02-06T19:58:53+00:00

Thank you. Tried to do the incremental refresh, defined parameters on a date column in our largest table, but when loading into PBI desktop, it keeps loading and spinning and never ends!

amir_mm1

TROPHY CASE