troubleshooting Question

Filter OData info with an Excel Spreadsheet in Power BI Desktop

Avatar of Jeremy Pierce
Jeremy PierceFlag for United States of America asked on
Power BIMicrosoft ExcelDesktopsMicrosoft Office
3 Comments1 Solution19 ViewsLast Modified:
I have an Odata database: https://data.texas.gov/api/odata/v4/naix-2893
And an Excel Workbook saved on the Desktop with a list of Bars and the TABC Permit #

I am trying to filter the Odata feed in Power BI to only show the TABC Permit #s that are listed in the excel sheet.

I use to do this in Excel only, but there have been complications with the feed and certain versions of Excel, plus I would like the reporting and graphics that Power BI has to offer.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros