rss.livelink.threads-in-node

API data sources

SamyAbdul — Wed, 14 Oct 2026 11:59:10 GMT

Hi Experts, we have to ingest the data from API , and we have options like direct API mode or APIM . There are nearly 10 data sources, and APIM would cost us. So which options we should go for on which scenario, do we have any benchmark criteria in terms of performance, and costs.

dynamic format string live connection issue

powerbiexpert22 — Wed, 14 Oct 2026 10:51:21 GMT

i am working on report which is connected live to semantic model stored on power bi service, i am unable to apply dynamic string format (feature as explained in below tutorial ) since it does not work on live connection

i have downloaded the latest copy of semantic model, how do i repoint my report from live to local using import? is there any alternative way to apply dynamic format string without changing or repointing the report to local semantic model?

https://www.youtube.com/watch?v=s4jeX9EKON4&pp=ygUhZHluYW1pYyBmb3JtYXQgc3RyaW5nIGluIHBvd2VyIGJp

Looking to connect with teams using Power BI for self-service reporting and insights

NatalieGraham — Wed, 14 Oct 2026 10:13:39 GMT

I lead product management for HR dashboards at a large organization, and we're migrating our self-service analytics reporting to Power BI. I have 13+ years in People Analytics, mostly on other BI platforms, so I'm looking to learn from teams already doing this well.

I'd love to hear from HR or other functional leaders leaders who use Power BI for end-user self-service. In particular:

Dashboard design: What does a great dashboard look like in Power BI? What are the art of the possibilities? Any examples or design patterns you'd recommend?
Adoption and enablement: What training and support materials worked best for non-technical end users (for example, filtering, slicers, bookmarks, and exporting)?
Governance: How do you manage workspaces and apps, and handle row-level security for sensitive HR data?
Lessons learned: What would you do differently if you were migrating again?

I'd also welcome a short conversation or demo with anyone willing to share how their team uses Power BI. Please reply here or message me directly. Thanks Natalie

How show in a table only records that meet with the disconnected date select

gomezc73 — Wed, 14 Oct 2026 10:11:21 GMT

Hi Expert I need help.

I have file that contains all journal entries from 01/01/2024 until today.

This is an example of the data(the original has more data)

Gl_Date	YYYYMM	PO	Journal	Amount USD	Invoice#	Supplier#	category
1/1/2026	202601	PO345	JE example 01	10.00	INVO345	56677	Payments
10/1/2026	202610	PO356	JE example 02	120.00	INVO356	67890	Purchase Invoices
9/1/2025	202509	PO157	JE example 03	60.00	INVO157	87999	Payments
6/2/2024	202406	PO345	JE example 04	345.00	INVO345	96666	Purchase Invoices
3/3/2026	202603	PO890	JE example 05	1,200.00	INVO890	64444	Receiving
2/4/2025	202502		JE example 06	900.00			Non-REC Reversing >1M
8/5/2024	202408	PO345	JE example 07	890.00	INVO345	56677	Payments
2/6/2024	202402	PO109	JE example 08	35.00	INVO109	90666	Purchase Invoices
10/7/2026	202610	PO900	JE example 09	568.00	INVO900	56777	Receiving
4/8/2025	202504		JE example 10	923.00			Retro-Price Adjust
7/9/2026	202607		JE example 11	689.00			Revaluation

In my dashboard, the user need see ALL the records until a date selected from a Slicer.

SO, I've created a disconnected calendar table to add a Slicer to select a YYYYMM.

But when i tried to show only data from 01/01/2024 until the YYYYMM selected, always shows all the records in the file, I can't find a way to show only records with YYYYMM less or equal to the date selected in the Slicer.

Is it possible?

Report Server Migration

lherbert501 — Wed, 14 Oct 2026 09:59:41 GMT

Hi,

Do people have a preferred method of server migration with their Power Bi Reports?

If you had multiple PBIX's and they were all changing server, is there another option that people would use instead of going into each PBIX separately and manually changing the server field?

Thanks

Fabric Copy Job CDC Error On Incremental Load

joel_delima — Wed, 14 Oct 2026 09:45:28 GMT

I'm using the fabric copy job to incrementally copy data from a CDC enabled table on SQL Server 2008 R2. The initial full load ran successfully, however all subsequent runs are failing and returning the following error:

Failure happened on 'Source' side. ErrorCode=SqlOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=A database operation failed with the following error: 'Incorrect syntax near '.'.'

I'm assuming the error is caused by some dynamic sql script generated by the copy job in the backend. Does anyone know how I can determine what's actually causing this error, and how I can fix it?

For context, this error is happening on our production SQL Server 2008. I tested the same copy job on our dev SQL Server 2008 and had no issues whatsoever with the initial load and incremental runs. Both SQL Servers are identical.

Decision on using Fabric SQL or Fabric Warehouse

XhevahirMehalla — Wed, 14 Oct 2026 09:39:17 GMT

Hello,

We are trying to migrate from synapse to fabric.

Current solution is:

source data= oracle OCI

use Synapse Pipelines to copy oracle data to ADLS Gen 2.

Synapse Dataflow to transform and destination is Azure SQL db. Serverless. We use this as DWH.

a New client has more than 6TB of data.

What data store we will use as the gold layer where we can build reports:

fabric warehouse or fabric sql db since we are in Azure sql db?

I yet to understand the hyperscale version and if this help chose fabric sql db?

thanks

Allow multi-column conditions /output in Power BI Activator rules (Power BI visual-based alerts)

AdityaPrasad — Wed, 14 Oct 2026 09:14:30 GMT

Description:

When I create an Activator alert from a Power BI report visual, the rule can only evaluate the single column or measure it was created from, and the alert can only reference that same value. This blocks common governance and monitoring scenarios.

Example scenario:
I wanted an alert for Dev workspaces that sit on a billable (Premium/Fabric) capacity. That needs a condition on both Workspace Name (contains “Dev”) and Capacity/Billing type (not blank). Activator can’t combine the two in one rule, so I had to build the alert in Power Automate with a DAX query instead.

Limitations:

A condition can use only one column or measure, with no AND/OR across several attributes.
The alert message or action can include only that same column. I can’t add related details like workspace name, dataset link, or owner.
There’s no way to run a DAX query as the rule logic.

Requested improvements:

Conditions across multiple columns/measures (AND/OR).
Selectable output fields, so the Teams or email action can include several columns, and dynamic links.
Optionally, the ability to define the trigger with a DAX query, as the Power Automate “Run a query against a dataset” action does.

Impact: Without this, governance and monitoring alerts need a separate Power Automate flow, which is harder to build and maintain than a native Activator rule.

Allow multi-column conditions/output in Power BI Activator rules (Power BI visual-based alerts)

AdityaPrasad — Wed, 14 Oct 2026 09:12:57 GMT

Description:

Limitations:

A condition can use only one column or measure, with no AND/OR across several attributes.
The alert message or action can include only that same column. I can’t add related details like workspace name, dataset link, or owner.
There’s no way to run a DAX query as the rule logic.

Requested improvements:

Conditions across multiple columns/measures (AND/OR).
Selectable output fields, so the Teams or email action can include several columns, and dynamic links.
Optionally, the ability to define the trigger with a DAX query, as the Power Automate “Run a query against a dataset” action does.

Workout Wednesday 2026 Week 42 | Power BI: Overlay Information With Bookmarks

vivienlee — Wed, 14 Oct 2026 09:10:31 GMT

Hi everyone, this is my submission for this week's Workout Wednesday!

Bookmarks can be a little bit tricky sometimes especially when there's lots of elements to show and hide. This Workout Wednesday uses 4 bookmarks (and even more for the bonus challenge) but it's so satisfying when it comes together. This is especially useful if there's parts of your dashboard that you'd like to explain to the user and you don't feel like a tooltip is enough.

FabricSqlEndpointMetadata Connector kind is not valid for RefreshSqlEndpoint Activity

fpvmorais1 — Wed, 14 Oct 2026 08:42:40 GMT

Hi,

I am getting this error when configuring a RefreshSqlEndpoint:

I've recreated the connection and I am also using OAuth with a service account.

Any tips on what I could be doing wrong?

Thanks

Alert on Dashboard triggers on every data refresh, how to make it trigger on change only?

SevsBo — Wed, 14 Oct 2026 08:36:54 GMT

We set up a simple dashboard with several card visuals, so that our key stakeholders can set up alerts, and so far we have tested this approach with one of the stakeholders.

The rules on the selected visual are very simple: if the value exceeds 1 or drops below -1, notify the stakeholder. Anything between those two values we don't care about.

We have a tri-weekly update scheduled on that report, and when the data updated on Monday an alert was sent, just as expected. The problem was that another alert then got sent on Wednesday as well, when the report updated again, even though the underlying data has not changed.

Just for some background, our data is only updated only once a month, but we can't guarantee it will always be on the same day, hence the tri-weekly update. So we want the alert to only be sent out once - when (if) the data changes and is within the scope of the alert.

So, if previous month's report resulted in -1.1, and the new one is -1.0, we would still want the alert to be sent. But we don't want the alert to be sent multiple times in the same month if the data update has already happened.

Is that possible?

Fabric warehouse SQL editor: improve Ctrl-Enter

stegus64 — Wed, 14 Oct 2026 08:29:34 GMT

Today the Fabric warehouse SQL editor executes the full text in the editor when you press Ctrl-Enter without anything selected.

It would be very convenient if Ctrl-enter only executed the single sql query where the cursor is positioned. This is the behavior used in DBeaver.

It is very common that you have a lot of different queries in a sql file for ad-hoc troubleshooting. Today you need to manually select a query before executing it. With this change it would be enough to simply move the cursor inside any query and press Ctrl-enter.

You are already highlighting the current query in green, so having Ctrl-enter only executing the green part would be very intuitive.

Fabric Activator was unable to activate your rule

mtimoulal — Wed, 14 Oct 2026 08:18:13 GMT

Activator encountered a problem and was unable to activate your rule. look for the notification type listed below.

Microsoft Fabric Pipeline Authentication Error – AADSTS50173

MithunYadav07 — Wed, 14 Oct 2026 08:15:50 GMT

Hi everyone,

I'm encountering an authentication issue while running a pipeline in Microsoft Fabric. The pipeline is failing with the following error:

Error Message:

ArtifactConnection_InaccessibleDatasource AADSTS50173: The provided grant has expired due to it being revoked. A fresh auth token is needed.

Has anyone encountered this issue before? Could you please help me understand the root cause and suggest how to resolve it?

I would also appreciate any recommendations for preventing this issue from recurring in production pipelines.

The column 't5.c514' of the table was not found

mkumarcharla — Wed, 14 Oct 2026 07:54:39 GMT

The error indicates that the t5.c514 column is being referenced during the underlying query/model processing but is not available in the returned result set.
Captured the query execution using DAX Studio → Server Timings to identify the underlying SQL generated for the DAX query.
Reviewed the SQL generated in Server Timings and validated the SQL statements executed against the backend.
No reference to t5.c514 was found in the generated SQL.
The generated SQL does not contain a column or alias explicitly referencing t5.c514, even though the Power Query/Mashup error reports that this column is missing.
To further isolate the issue, we selected individual columns from the _Employee Assignment Information table and executed separate DAX queries to validate whether the issue was specific to a particular column.
But the issue did not occur when selected few particular columns, can someone please help, what exactly the c514 column the engine to mapping to ?

DAX Query:TOPN(100, '_Employee Assignment Information')
EVALUATE

Profit & Loss Analysis Dashboard

PowerbiKenny — Wed, 14 Oct 2026 07:46:28 GMT

An interactive Excel dashboard for financial reviews and budget variance analysis, designed for finance managers, FP&A analysts, and finance business partners.

Explore revenue, costs, expenses, and profitability through four connected sections:

Overview: Key financial metrics, monthly trends, and a profit waterfall.
Comparison: Actual results versus budget and prior year.
Variance Analysis: Profit gaps by category, product-line margins, and account-level variances.
Follow-up: Dynamic summaries and space to record actions and responsibilities.

Filter by year, region, and product line to explore performance. Built with Power Query, the Excel Data Model, and DAX, using simulated business data.

One-Click Dashboard Generation · Custom Templates · Consulting

For one-click dashboard generation solutions, tailored financial reporting templates, or consulting, contact:

powerbikenny@hotmail.com

The column 't5.c514' of the table was not found

mkumarcharla — Wed, 14 Oct 2026 07:38:15 GMT

The error indicates that the t5.c514 column is being referenced during the underlying query/model processing but is not available in the returned result set.
Captured the query execution using DAX Studio → Server Timings to identify the underlying SQL generated for the DAX query.
Reviewed the SQL generated in Server Timings and validated the SQL statements executed against the backend.
No reference to t5.c514 was found in the generated SQL.
The generated SQL does not contain a column or alias explicitly referencing t5.c514, even though the Power Query/Mashup error reports that this column is missing.
To further isolate the issue, we selected individual columns from the _Employee Assignment Information table and executed separate DAX queries to validate whether the issue was specific to a particular column.
But the issue did not occur when selected few particular columns, can someone please help, what exactly the c514 column the engine to mapping to ?

DAX Query:
EVALUATE
TOPN(100, '_Employee Assignment Information')

New Monitoring Hub

cjac02 — Wed, 14 Oct 2026 07:27:50 GMT

Enjoying the new monitoring hub and the insights it brings. However, I have a few suggestions

Display Start Time and Current Duration
When clicking on Workspace, take me to the Workspace - like the Legacy Hub
Remove the Pagination, we have a very busy capacity that we need to monitor
Alerts for any running job that exceeds a time threshold, eg send email to admins where any refresh is taking longer than 60 minutes

Power BI Service Refresh Fails with DataFormat. Error 10942 - Desktop Refresh Works.

sahilgaud — Wed, 14 Oct 2026 06:39:51 GMT

Hi Everyone,

I need help troubleshooting a persistent Power BI Service refresh issue. I have spent considerable time debugging it using Copilot, AI assistance, YouTube tutorials, and community suggestions, but the issue remains unresolved.

1. Issue and Error

My Power BI report refreshes successfully in Power BI Desktop, usually within 7–15 minutes, but every refresh fails in Power BI Service.

Exact error:

DataFormat.Error: We were unable to load this Excel file because we couldn't understand its format. File contains corrupted data. Microsoft.Data.Mashup.ErrorCode = 10942.

The error appears while processing the semantic model.

2. Data Source and Dashboard Logic

Data source: SharePoint folder using SharePoint.Files() in Power Query.

SharePoint contains approximately 900 MB+ of data and hundreds of files.

Files are spread across five folders, containing Excel and CSV files.

Power Query filters files by folder path, imports Excel workbooks using Excel.Workbook(), promotes headers, changes data types, and combines files using the Combine Files / Transform Sample File mechanism.

Multiple queries depend on a common BASE SOURCE query. These queries process different datasets, including MAIN, PROFILES, LOGIN, BREAK, QC, ABANDON, and other reporting datasets.

The processed data is used in my VKYC Daily Reporting Dashboard.

3. Troubleshooting Already Done

I have already tried:

Re-authenticating SharePoint and Power BI Service data-source credentials.

Checking file extensions, file formats, column names, data types, and historical schema differences.

Standardising the historical ACHT column and newer TaskID column to TaskID.

Checking for desktop.ini and other unexpected files.

Reviewing Power Query dependencies and the Transform File / Transform Sample File helper queries.

Testing try...otherwise logic and adjusting Excel sheet navigation.

Checking queries individually. The MAIN query was the first to show an error during one Desktop debugging attempt; other queries failed because of dependencies.

Creating a separate test PBIX and rebuilding the Combine Files logic, then publishing it to Service. The test PBIX also refreshes in Desktop but fails in Service with the same error.

I have also checked the SharePoint file metadata, but I still cannot identify the exact file causing the problem.

4. Help Needed

Could someone please suggest a reliable way to:

Identify the exact Excel file causing DataFormat.Error 10942 during Power BI Service refresh?

Log the file name and folder path of files that fail when Excel.Workbook() processes them?

Diagnose why Service fails while Desktop refresh succeeds?

Test or isolate problematic files without manually opening hundreds of files or rebuilding the entire dashboard?

Use Power Query M code or another diagnostic method to capture the failing file and error details?

I would particularly appreciate a practical, step-by-step solution or sample M code that can help identify the exact failing file.

I have already tried multiple troubleshooting approaches and would really appreciate expert guidance. Thank you!