Riccardo Perico

Trigger Power BI model refresh from a report with Translytical Task Flow Let them run their refreshes

I’m sure one of the most requested features from your users is: ‘Can you add a button to refresh the model behind this #Powerbi report?’

With #TranslyticalTaskFlows, we now have an option, using only #Fabric artifacts, even if the user does not have direct access to the semantic model.

SQL Server 2025 triggering a Power BI Model Refresh via T-SQL sp_invoke_external_rest_endpoint unlocks wide range of scenarios

#SQLServer2025 introduces #sp_invoke_external_rest_endpoint, allowing #TSQL to call REST APIs directly. This feature can be leveraged to trigger a #PowerBI dataset refresh immediately after a SQL Server ETL process completes.

Power BI Deployment Pipelines & Parameter Rules Parameter type matters

As of now, #PowerBI #DeploymentPipelines do not support parameters of type Any or parameters of type Text with a list of values even if it’s not clearly stated in the documentation.

Keep in mind while you define your #PowerQuery.

medium.com/riccardo-per...

Power BI Desktop & TMDL this is not a valid path TMDL View prevents to save PBIX file

If you’re using #TMDL view in #PowerBIDesktop, be aware that saving #PBIX files may fail if your client language is not English.

Here's why.

medium.com/riccardo-per...

MDS Excel Add-in Suddenly Unresponsive Why the SQL Server MDS Excel add-in stops working and how to resolve it

#SQLServer #MDS includes an #Excel add-in used to interact with its database, and it relies on #ActiveX. If you’re running Excel Version 2504 or later, be aware that ActiveX may be disabled by default due to a new policy introduced by the #Office product team.

medium.com/riccardo-per...

yes, probably only Spain and Greece are hit most than Italy.

Florence should be even worst than Rome.
Touched almost 40 last weekend.

between 33-35 expected here today and tomorrow in the north on Italy... close to the mountains... we are cooked

From SSAS Tabular to Power BI semantic model at the speed of light Just another use case for powerful TMDL

In this blog post, I’d like to focus on how Davide Lambertini and I leveraged #tmdl to migrate a #sqlserver #ssas tabular model to #powerbi semantic model at the speed of light just using #tabulareditor2 and #tmdlview.

medium.com/riccardo-per...

Power BI can feed your Data Pipelines How to leverage Semantic Model not to reinvent the wheel

If we’re in a #PowerBI only ecosystem, the semantic model usually seems like the endpoint of our pipeline. However, it can serve as the starting point for another pipe. For example, using ETL/ELT tools, you can feed one semantic model using the output from another.

medium.com/riccardo-per...

Power BI live over SSAS via OPDG The connection suddenly stopped working

nobody touched the #SSAS instance, the #Tabular database, the #OPDG or the #PBI semantic model but the live connection is broken.

perico-riccardo.medium.com/power-bi-liv...

Developer Community Developer Community

If you wish to have an “Execute” shortcut on top of each query letting you run whatever you need without selecting the statement in #SSMS you can up vote this idea.

developercommunity.visualstudio.com/t/quick-exec...

Santa is 9 months early this year.

Thank you very much Ashley Felts and Marisa Mathews for welcoming in the #FabricCommunity as a #FabricSuperUser.

It’s an honor being part of it.

#powerbi #fabric #community

Azure Data Studio is dead, and now? Is Visual Studio Code ready to rock?

#Microsoft announced the retirement of #AzureDataStudio.
Is #VisualStudioCode ready to replace it?

perico-riccardo.medium.com/b5a57139b2d5

Bypass identity column limitation in Fabric Warehouse SQL databases to the rescue and opening new scenarios

Microsoft #Fabric #Warehouses don't support identity or sequence.
#SQLdatabase can bypass it and open many more scenarios.
At some extent we could have found a way of defusing the lack of #TSQL functionalities in #Fabric #Warehouses

medium.com/riccardo-per...

RemoveDiscontinuedFeatures with EnsureProperEncryption error in Visual Studio 2022 Be aware of it while migrating to SSAS 2022 CU1 and above

If you migrate from earlier versions to #SSAS2022 you could be asked to "Remove Discontinued Featured".
#SQLServer2022 introduced new security features that you should be aware even while working in #visualstudio

perico-riccardo.medium.com/removediscon...

Sessions of #PowerBI and #MicrosoftFabric Summit 2025 are now LIVE

check out the list of amazing speakers, the wide range of sessions, and the agenda all in here:

globalpowerbisummit.com

Join the biggest gathering of Power BI and Fabric #DataAnalytics #Analytics #Conference in Feb 2025

Snowflake extension for Visual Studio Code Please, make me more productive

If you're relying on #Snowflake to build your analytics platform the official #vscode extension is a valuable complement to the web interface and we'll make your more productive.

medium.com/riccardo-per...

my 2024

a cartoon of sonic the hedgehog with the words gotta go fast behind him ALT: a cartoon of sonic the hedgehog with the words gotta go fast behind him

using #chatgpt to generate #markdown tables to be inserted in #DevOps wiki

The new workspace monitoring is based on Log Anlytics and for semantic models leverages AAS XE. I think the product team can leverage the same concept using XE from the SQL and sending them to the KQL of the monitoring. Maybe it's one step away.

I tried with the profiler in Azure Data Studio that manages authentication sending you to browser. it doesn't work because it expects DMVs that don't exist.

can sql profiler be attached to the sql endpoint?

Migrating from Premium (P*) to Fabric (F*) capacity Easy task, right? Or maybe not

Migrating from #PowerBI #Premium capacity to #Fabric capacity is not a complicated task if your environment is simple.

However it can become challenging, especially if the migration needs to be done across different regions.

perico-riccardo.medium.com/migrating-fr...

And we just closed a conversation with a big customer that thinks #Fabric is not "ready enough" and want to use #Synapse for the next big project

I think they're rumors but nothing official.
Many people think it.
I would assume Synapse will be there in the future as AAS without any further improvement.

“Is large” is there in api indeed. Modified by xmla seems missing also there

#sqlfamily is there anyone out there that knows which semantic model properties store:
- large semantic model option
- modified via xmla endpoint

trying to get them from TOM but can't find it. Even #tabulareditor seems not to be aware of them

It turns out that #pbir (power bi report enhanced report format) is now supported in Power BI App.

The most update limitations list can be found here:

lnkd.in/dSqFX9Ym

If you please, join me in “black room” at 3PM to talk about the evolution of #fabric and #powerbi #cicd at #wpc2024