- 57
- 12 333
Ricardo Gondo
Brazil
เข้าร่วมเมื่อ 19 ก.ย. 2011
Power BI Making a Report a bit Less Static with Parameters list
Here is the PBI file
github.com/ricardokazuo/powerbyme/raw/refs/heads/main/Parameters_Sales.pbix
github.com/ricardokazuo/powerbyme/raw/refs/heads/main/Parameters_Sales.pbix
มุมมอง: 48
วีดีโอ
Databricks Publishing a Strealit App to Export data - from hero to almost super hero
มุมมอง 3214 วันที่ผ่านมา
In this video I connect the dots, from creating a Streamlit app to build the query, to store it on a Databricks volume, to build the notebook job to run the query and send the file link via email. This is the Streamlit_query_builder.py github.com/ricardokazuo/notebooks/raw/refs/heads/main/streamlit_query_builder.py This is the python file to read the custom query, execute the query, compress th...
From Zero to Hero - Databricks
มุมมอง 4421 วันที่ผ่านมา
In this video I show some cool stuff in a Databricks environment, enjoy! The notebook is here github.com/ricardokazuo/notebooks/raw/refs/heads/main/First.ipynb
From Zero to Hero - Streamlit - With Claude and Gemini
มุมมอง 11321 วันที่ผ่านมา
Let's create a sample data and then a Streamlit page! This is the link for the files: github.com/ricardokazuo/notebooks/raw/refs/heads/main/country_sales.zip
The Databricks Extractor - 10M rows by 60 columns - ザー Databricks エクスポーター!
มุมมอง 928 วันที่ผ่านมา
In this video I show how to extract large amount of data from Databricks via Python notebook. Enjoy! The file is here: github.com/ricardokazuo/notebooks/raw/refs/heads/main/TheExtractor
Databricking - Creating a Streamlit app
มุมมอง 5628 วันที่ผ่านมา
In this video I show how to create a Streamlit app in Databricks cloud. Enjoy!
Fantastic! Azure Databricks first attempt to create a notebook
มุมมอง 37หลายเดือนก่อน
With the help of my chatbots
Database Extractor App
มุมมอง 27หลายเดือนก่อน
In this video I show my latest extractor app. It reads from our database and based on the chosen filters, it downloads the data from the tables. This is the link github.com/ricardokazuo/notebooks/blob/9557da66da13f4442016038f4e4f1ad50b7d0116/streamlit_extractor.py
SuperBob with Gemini & Claude & OpenAI
มุมมอง 18หลายเดือนก่อน
In this latest version, we are not using tools any longer. The database schema is sent to the LLM and they build the query.
Financial ChatBob with OpenAI, Claude and Gemini APIs
มุมมอง 203 หลายเดือนก่อน
In this video I show how I generated a generic ChatBob using OpenAI, Claude and Gemini LLMs. The file is here bit.ly/chatbob_10
From a ChatBot to the SmartBob with OpenAI
มุมมอง 344 หลายเดือนก่อน
In here I show a very nice implementation of chatbot using langchain agents.
Python Dash Plotly - Callback Function - Dynamic List
มุมมอง 346 หลายเดือนก่อน
In this video I show how to create a dynamic callback function with a list based on a txt file. The file is here github.ricardo.expert/dash-dynamic-callback
Copilot & I - Dashboard with Flask-SocketIO
มุมมอง 777 หลายเดือนก่อน
This is a follow up to the first Copilot Dashboard video. In this one we use the SocketIO with generic endopoint to serve all three endpoints with just one file. The zip file is here github.com/ricardokazuo/notebooks/blob/948e2d5d7880c8f71f68c61e34727e6647238162/Gauge-SocketIO.zip
Copilot & I - Sysinfo Dashboard an Introduction
มุมมอง 307 หลายเดือนก่อน
Having fun with Copilot The code is here: bi.ricardo.expert/git-gauge
Refreshing only one table on the Semantic Model
มุมมอง 1157 หลายเดือนก่อน
Refreshing only one table on the Semantic Model
Power BI How to Merge two Reports into one Semantic Model
มุมมอง 2.7K7 หลายเดือนก่อน
Power BI How to Merge two Reports into one Semantic Model
SQL Server Varchar Columns vs Float Columns
มุมมอง 307 หลายเดือนก่อน
SQL Server Varchar Columns vs Float Columns
Power BI Opening a file regardless of its name
มุมมอง 349 หลายเดือนก่อน
Power BI Opening a file regardless of its name
Live Data from Coinbase via Python SocketIO
มุมมอง 419 หลายเดือนก่อน
Live Data from Coinbase via Python SocketIO
Power Query - ETL - Translations via Google Translator API
มุมมอง 20710 หลายเดือนก่อน
Power Query - ETL - Translations via Google Translator API
Power Query - ETL - Tradução via Google Translate API
มุมมอง 9110 หลายเดือนก่อน
Power Query - ETL - Tradução via Google Translate API
Thank you for this video. I’m looking to start a business making videos and Word documents where I’ll need translations for closed captions for the videos and document translations that include formatting in the Word documents. Microsoft Translator is supposed to have the most languages and be the most accurate but you need an Azure account to add Translator to, then you need to add storage to set up an upload and export folder. At that point you need to tie everything together and then you can use Power Automate to move a document from the SharePoint to the Azure upload folder to start the translation. This can further be automated through Python scripts but it’s amazing that AI can still only achieve an 85% accuracy in translating some languages. It’s outrageous that Microsoft makes it so difficult to set up a translation for what is essentially a free service if you don’t go over the limit, and when you do pay there can be up to a 15% error rate. People are worried about AI taking over. Microsoft has been around since the 70’s and they still can translate languages that have been around thousands of years with 100% accuracy so I think we’re safe! Happy New Year!
Excelent content!
Let's go!!!!!!!!!!!
HI Richardo, tqsm on this video! I have a question to ask, if I were to create 2 reports on 1 semantic model like you did, will the RLS works for both reports? Say 1st report for manager, 2nd report for sales team, technically both reports are the same, just that the sales team report I have hidden the manager's page, then I want to create RLS in the model so that each sales can only see his data on the 2nd report. what is the "correct" way to do this?
That is easy to test, I believe, If you already has it done, just copy and paste a second one and connect it to the first semantic model via Power BI Desktop and see how it goes. I believe there won't be any issues.
awesome job
Thanks a bunch!
Thanks for sharing with us
Will this work if the 2 reports exist in different workspaces?
Most likely not, some testing is required.
Nice to share your knowledge. How can someone combine tables from different multiple Power BI Sematic models to create a new Semantic Model?
I believe you will have to combine the tables via power query, them publish it as a new semantic model.
@@ricgondo I am not sure you can import Semantic Model into Power Query Editor. Let me know if there's a way pls.
@@BanwoAdewale you are correct, but I was under the impression you had access to the original file.
@@ricgondo The Semantic Models were created by someone else but I have access. I want to use some tables from those models to build a new Semantic Model for my use case.
when we create dashboard, how we get the embeded url
Super cool video. Thanks for your video
Awesome, thanks for sharing.
Thanks for watching!
Thank you for this video, I've been searching for this solution for days and everyone was suggesting creating the report with the existing semantic model from the scratch!
@@melikagerami I’m very glad I was able to help!
So cool..
I think so as well!
i like your videos and would like to talk about some doubst i have on pbi on my work i can pay for you time
Everything else is working fine, but field parameters are not working in this method. Getting something is wrong with one or more fields(for all of my parameters).
Thank you so much, Ricardo, for publishing this video. This is a really useful thing to be able to do and I couldn't find how to do this from any other videos. (Also, multiple searches in AI tools told me either it couldn't be done or they responded with an outright hallucination.)
@@dougmorris546 I’m very glad this was helpful! And I’m also happy to know The AI didn’t find my videos yet :-)
When it comes to a hardware resource, how do multiprocess/multithread applications handle accessing the same device? For example, one task may need to always control a radio frequency, while another task just listens and analyzes the incoming data? The write side can be a very responsive GUI, while the read is always busy analyzing and pushing elements of the GUI to update?