Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I imported data from a MS Access query and one column (LEVEL) is null in Power BI. Another column's values are changed to "Other". There are no null values or "Other" in for these columns in the MS Access query. Has anyone else ran into this issue before? Thanks
Hi @kbecker12
I cannot reproduce the same issue.Please check if this post could help.If it is not your case,you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Regards,
Thank you. I did submit a ticket the next day. The support team is working on this. I do not have identical column names in the queries that I am seeing this error. There are Access engineers looking into the issue now. I have to get this working, so in the meantime, I will use another approach. I pulled the individual records data in another program and aggregated it in Access. The nice thing about doing it in Access is it is so flexible and any updates or changes are simple to implement. However, at this point, I think it might be easier for me to connect directly to the data source through an Oracle connection. I am worried about the speed of the query and refresh though.
Additionally, I would check two things:
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you for the suggestions! I haven't tried to reinstall the Access Database Egnine yet, but the Databae compact and repair had no impact on this issue.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |