Riccardo Perico
@r1k91.bsky.social
BI Architect @ Lucient Italia | Microsoft Data Platform MVP
Blog: https://medium.com/riccardo-perico
LinkedIn: https://www.linkedin.com/in/riccardo-perico
GitHub: https://github.com/R1k91
Blog: https://medium.com/riccardo-perico
LinkedIn: https://www.linkedin.com/in/riccardo-perico
GitHub: https://github.com/R1k91
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.
With #TranslyticalTaskFlows, we now have an option, using only #Fabric artifacts, even if the user does not have direct access to the semantic model.
Trigger Power BI model refresh from a report with Translytical Task Flow
Let them run their refreshes
perico-riccardo.medium.com
September 18, 2025 at 11:07 AM
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.
With #TranslyticalTaskFlows, we now have an option, using only #Fabric artifacts, even if the user does not have direct access to the semantic model.
#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.
SQL Server 2025 triggering a Power BI Model Refresh via T-SQL
sp_invoke_external_rest_endpoint unlocks wide range of scenarios
medium.com
August 24, 2025 at 1:28 PM
#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.
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...
Keep in mind while you define your #PowerQuery.
medium.com/riccardo-per...
Power BI Deployment Pipelines & Parameter Rules
Parameter type matters
medium.com
August 18, 2025 at 6:01 PM
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...
Keep in mind while you define your #PowerQuery.
medium.com/riccardo-per...
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...
Here's why.
medium.com/riccardo-per...
Power BI Desktop & TMDL this is not a valid path
TMDL View prevents to save PBIX file
medium.com
July 24, 2025 at 2:25 PM
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...
Here's why.
medium.com/riccardo-per...
#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...
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
medium.com
July 18, 2025 at 10:37 AM
#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...
medium.com/riccardo-per...
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...
medium.com/riccardo-per...
From SSAS Tabular to Power BI semantic model at the speed of light
Just another use case for powerful TMDL
medium.com
June 16, 2025 at 5:06 PM
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...
medium.com/riccardo-per...
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...
medium.com/riccardo-per...
Power BI can feed your Data Pipelines
How to leverage Semantic Model not to reinvent the wheel
medium.com
April 28, 2025 at 7:14 AM
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...
medium.com/riccardo-per...
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...
perico-riccardo.medium.com/power-bi-liv...
Power BI live over SSAS via OPDG
The connection suddenly stopped working
perico-riccardo.medium.com
April 8, 2025 at 8:55 AM
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...
perico-riccardo.medium.com/power-bi-liv...
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...
developercommunity.visualstudio.com/t/quick-exec...
Developer Community
Developer Community
developercommunity.visualstudio.com
March 7, 2025 at 8:14 AM
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...
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
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
March 7, 2025 at 7:58 AM
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
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
#Microsoft announced the retirement of #AzureDataStudio.
Is #VisualStudioCode ready to replace it?
perico-riccardo.medium.com/b5a57139b2d5
Is #VisualStudioCode ready to replace it?
perico-riccardo.medium.com/b5a57139b2d5
Azure Data Studio is dead, and now?
Is Visual Studio Code ready to rock?
perico-riccardo.medium.com
February 28, 2025 at 3:57 PM
#Microsoft announced the retirement of #AzureDataStudio.
Is #VisualStudioCode ready to replace it?
perico-riccardo.medium.com/b5a57139b2d5
Is #VisualStudioCode ready to replace it?
perico-riccardo.medium.com/b5a57139b2d5
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...
#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...
Bypass identity column limitation in Fabric Warehouse
SQL databases to the rescue and opening new scenarios
medium.com
January 31, 2025 at 6:04 PM
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...
#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...
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...
#SQLServer2022 introduced new security features that you should be aware even while working in #visualstudio
perico-riccardo.medium.com/removediscon...
RemoveDiscontinuedFeatures with EnsureProperEncryption error in Visual Studio 2022
Be aware of it while migrating to SSAS 2022 CU1 and above
perico-riccardo.medium.com
January 28, 2025 at 8:49 AM
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...
#SQLServer2022 introduced new security features that you should be aware even while working in #visualstudio
perico-riccardo.medium.com/removediscon...
Reposted by Riccardo Perico
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
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
January 6, 2025 at 11:07 PM
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
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
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...
medium.com/riccardo-per...
Snowflake extension for Visual Studio Code
Please, make me more productive
medium.com
January 7, 2025 at 7:01 AM
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...
medium.com/riccardo-per...
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...
However it can become challenging, especially if the migration needs to be done across different regions.
perico-riccardo.medium.com/migrating-fr...
Migrating from Premium (P*) to Fabric (F*) capacity
Easy task, right? Or maybe not
perico-riccardo.medium.com
December 16, 2024 at 1:25 PM
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...
However it can become challenging, especially if the migration needs to be done across different regions.
perico-riccardo.medium.com/migrating-fr...
#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
- 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
December 3, 2024 at 1:32 PM
#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
- 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
The most update limitations list can be found here:
lnkd.in/dSqFX9Ym
LinkedIn
This link will take you to a page that’s not on LinkedIn
lnkd.in
November 30, 2024 at 4:16 PM
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
The most update limitations list can be found here:
lnkd.in/dSqFX9Ym
Last Saturday I spoke about #SQLServer database projects at #datasat64 in Parma (IT).
You can find the slides on my GitHub.
github.com/R1k91/Commun...
You can find the slides on my GitHub.
github.com/R1k91/Commun...
CommunityEvents/2024/DataSaturday0064 at main · R1k91/CommunityEvents
This repository stores all slides and material from my public events. - R1k91/CommunityEvents
github.com
November 25, 2024 at 9:55 AM
Last Saturday I spoke about #SQLServer database projects at #datasat64 in Parma (IT).
You can find the slides on my GitHub.
github.com/R1k91/Commun...
You can find the slides on my GitHub.
github.com/R1k91/Commun...
November 23, 2024 at 10:10 AM
How to Setup Power Query Source in Visual Studio 2022
Neo, you take the x86 pill or the x64 pill
medium.com
November 18, 2024 at 4:54 PM